How would you identify power users in our database using complex joins and aggregations at Delivery Hero?
Treat a power user as a customer with at least three completed orders, at least 100 in total completed order value, and orders from at least two restaurants during Q1 2025.
Output
- Return one row per qualifying customer with
user_id, user_name, city, completed_orders, total_spend, and restaurants_used.
- Exclude customers who do not meet all three criteria.
- Order by
total_spend descending, then completed_orders descending, then user_name ascending.
