Each answer is one row with one number.
- How many units are in stock, for all products together?
- What is the average product price? Round it to 2 decimal places.
- What is all the stock worth? For each product, multiply price by stock, then add up the results.
A new table, reviews, has a rating from 1 to 5. Some reviews have no rating (NULL).
- Think before you run it: what does
SELECT AVG(rating) FROM reviews;return? - Now count a missing rating as 0. Give the average rounded to 2 decimal places.