18.Totals Across Tables

Every customer with their number of orders: the customer's name, then the count. Customers without orders get 0.
Every category with its number of products: the category's name, then the count. Categories without products get 0.
The total of each order: the order id, then the sum of quantity * unit_price of its items.
The customers who spent more than 90 in total, over all their orders: the name, then the total.
Which customer spent the most?

Something unclear, wrong or missing?

Databaselab-db · PostgreSQL in your browser 0:00

SELECT c.name, o.id
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.id;

Ctrl↵runs the query · select text to run part of it

Objective 1 of 50/5 done

Orders per customer
Customer name, then the number of orders. 12 rows; two of them show 0.