Question

1. Write a query to list the names all products (by product code and name) and the average ordered quantity for each product with a product name that starts with 198 (if the product has never been ordered, then only show the product code and name). Order the result by ascending order of average ordered quantity.

Answer 1

select WorkCenterId, Count (ProducedIn_t.ProductID) as 'TotalProducts' from ProducedIn_t left outer join Product_t on Product_t.ProductID=Product_t.ProductID group by WorkCenterId