Having Clause | Dataford Interview Questions

Which SQL clause filters aggregated results (HAVING)?

Asked in the Online test stage. Using the provided customers and orders tables, calculate each customer's completed order count and total amount, returning only customers whose completed order total is at least 500.

Output

One row per qualifying customer.
Columns: customer_name, completed_order_count, and completed_total.
Sort by completed_total descending, then customer_name ascending.

Schema

customers

Column	Type	Description
customer_idPK	INT	Unique customer identifier
customer_name	VARCHAR(100)	Customer display name
email	VARCHAR(150)	Customer email address

orders

Column	Type	Description
order_idPK	INT	Unique order identifier
customer_id	INT	Referenced customer identifier
amount	DECIMAL(10,2)	Order amount
status	VARCHAR(20)	Order processing status

Your question is Having Clause. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem