SQL Group By and Having | Dataford Interview Questions

Given a scenario with two tables, Orders and Customers, write a query using GROUP BY and HAVING to identify customers who have placed more than five orders in the last month.

Assume "last month" means the previous calendar month relative to the database's current date. Include only orders placed during that period.

Output

Return one row per qualifying customer with customer_id, customer_name, and order_count.
Include only customers with more than five orders, ordered by order_count descending and customer_id ascending for ties.

Schema

customers

Column	Type	Description
customer_idPK	INT	Unique customer identifier
customer_name	VARCHAR(100)	Customer's full name
market	VARCHAR(50)	Customer market or region

orders

Column	Type	Description
order_idPK	INT	Unique order identifier
customer_id	INT	Customer who placed the order
order_date	DATE	Date the order was placed

Your question is SQL Group By and Having. 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