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

Computers and Technology

Nash Bray

22 February, 07:30

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.

+4

Answers (1)

Know the Answer?

Opie · 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