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...