Write Top 5 Products Query | Dataford Interview Questions

Glassdoor wants a quick view of which employer products generate the most sales revenue. Write a PostgreSQL query to return the top five products based on completed sales records.

Requirements

Calculate total sales revenue as quantity * unit_price for each product.
Exclude rows with a missing product name or unit price, then return the five highest-revenue products in descending order.

Schema

product_sales

Column	Type	Description
sale_idPK	INTEGER	Unique identifier for the sale
product_name	VARCHAR(100)	Name of the Glassdoor employer product
quantity	INTEGER	Number of product units sold
unit_price	NUMERIC(10,2)	Price for one product unit
sale_date	DATE	Date on which the sale occurred

Your question is Write Top 5 Products Query. 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

Glassdoor wants a quick view of which employer products generate the most sales revenue. Write a PostgreSQL query to return the top five products based on completed sales records.

Requirements

Calculate total sales revenue as quantity * unit_price for each product.
Exclude rows with a missing product name or unit price, then return the five highest-revenue products in descending order.

Schema

product_sales

Column	Type	Description
sale_idPK	INTEGER	Unique identifier for the sale
product_name	VARCHAR(100)	Name of the Glassdoor employer product
quantity	INTEGER	Number of product units sold
unit_price	NUMERIC(10,2)	Price for one product unit
sale_date	DATE	Date on which the sale occurred

Your question is Write Top 5 Products Query. 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.