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.

Question

Aydin

Computers & Technology

17 September, 00:49

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.

+1

Answers (1)

Know the Answer?

Ramon Hampton · 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