SQL practice: HAVING: Filtering the Groups

Find categories with more than 3 products.

Find customers (customer_id) who placed more than 3 orders.

Find branches with more than 4 Delivered orders.

Find customer_type values with 5 or more customers.

Find products (product_id) with total quantity sold above 150.

Find roles where the average salary is above 50000.

Find regions with more than one branch.

Find managers who have 2 or more people reporting to them.

Find branches that have at least one Cancelled order. (Think: which is it, WHERE or HAVING — or both?)

Fix this query so it correctly finds branches with more than 5 orders.