Interview Guides
You are given Demandbase-style CRM sales data and need to identify the top five customers by total sales. Write a PostgreSQL query that returns each customer's name and their total closed-won sales amount. Exclude opportunities that are not closed-won, and rank customers from highest to lowest total sales.
