Top Products Overall | Dataford Interview Questions

Write a SQL query to find the top five products by sales at Enova International.

Use the sales amount recorded for each transaction to calculate total sales for each product. Return only products with recorded product names, ordered from highest total sales to lowest, with product name as the tie-breaker.

Output

One row per product.
Columns: product_name and total_sales.
Include the five products with the highest total sales.
Order by total_sales descending, then product_name ascending.

Schema

product_sales

Column	Type	Description
sale_idPK	INT	Unique identifier for the sale transaction
product_name	VARCHAR(100)	Name of the product sold
sale_amount	NUMERIC(12,2)	Recorded sales amount for the transaction

Your question is Top Products Overall. Start with the requirements and the one table 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

Write a SQL query to find the top five products by sales at Enova International.

Output

One row per product.
Columns: product_name and total_sales.
Include the five products with the highest total sales.
Order by total_sales descending, then product_name ascending.

Schema

product_sales

Column	Type	Description
sale_idPK	INT	Unique identifier for the sale transaction
product_name	VARCHAR(100)	Name of the product sold
sale_amount	NUMERIC(12,2)	Recorded sales amount for the transaction

Your question is Top Products Overall. Start with the requirements and the one table 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.