Show the name of each supplier and the number of products

Question

1. Show the name of each supplier and the number of products they supply. Order by supplier name.
2. Show the name of each category and the number of products in each category. Only show categories that have more than three products. Order by category name.
3. Show the name and unitprice of the product that has the highest reorderlevel.
4. Show the categoryname of any categories that do not have products in them.
5. Show the orderID, orderDate, productname, and quantity of every line on every order. Order by orderID and productName.
6. Write the insert statement to add Barnard Rubble, whose nickname is Barney, and his cell number is 888-867-5309.
7. Write the update statement to change Barney's nickname to Barnie, and his UnivIDNumOld to 8501234567.
8. Write the delete statement to delete all the roles for the person with ID 10511.
9. Show the name of each supplier and the number of products they supply. Order by supplier name.
10. Show the name of each category and the number of products in each category. Only show categories that have more than three products. Order by category name.
11. Show the name and unitprice of the product that has the highest reorderlevel.
12. Show the categoryname of any categories that do not have products in them.
13. Show the orderID, orderDate, productname, and quantity of every line on every order. Order by orderID and productName.

 

1. Write the insert statement to add Barnard Rubble, whose nickname is Barney, and his cell number is 888-867-5309.
2. Write the update statement to change Barney's nickname to Barnie, and his UnivIDNumOld to 8501234567.
3. Write the delete statement to delete all the roles for the person with ID 10511.