Join with Aggregation and Filtering
Hard
joins
LinkedIn
Uber
Stripe
Write a query to find customers who have placed more than 2 orders. Join customers and orders, group by customer, and filter using HAVING. Return customer_name and order_count, ordered by order_count DESC.
Expected Output: Customers with more than 2 orders.
Tables
Hints (3 available)
SQL Editor
Output
Click "Run" to see results...