12.Keep Some Groups

The editor counts the orders of each customer. Keep only the groups that each task asks for.

Show customer_id and the number of orders, only for customers with 2 or more orders.
From order_items, show product_id and the total quantity sold, only for products with a total of 3 or more.
From order_items, show order_id and the order's total: quantity times unit_price, added up for the order. Keep only the orders worth more than 50.00.
How many orders are worth more than 50.00?

Something unclear, wrong or missing?

Databaselab-db · PostgreSQL in your browser 0:00

SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id;

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

Objective 1 of 40/4 done

Customers with 2 or more orders
customer_id, then the number of orders. Only customers with at least 2 orders.