Top Server Configurations by Region | Dataford Interview Questions

Write a SQL query to find the top three highest-selling server configurations by region over the last quarter.

Use the sales, server_configurations, and regions tables. Interpret last quarter as the completed calendar quarter immediately before the current quarter.

Output

One row per selected configuration and region, with region_name, configuration_name, total_units_sold, and sales_rank.
Include no more than three configurations per region, ordered by region and descending sales rank.
Break equal sales totals by configuration_name alphabetically.

Schema

sales

Column	Type	Description
sale_idPK	INT	Unique sales transaction identifier
region_id	INT	Region associated with the sale
configuration_id	INT	Server configuration sold
sale_date	DATE	Date of the sale
units_sold	INT	Number of units sold in the transaction

server_configurations

Column	Type	Description
configuration_idPK	INT	Unique server configuration identifier
configuration_name	VARCHAR(100)	Supermicro server configuration name
description	VARCHAR(255)	Optional configuration description

regions

Column	Type	Description
region_idPK	INT	Unique sales region identifier
region_name	VARCHAR(100)	Sales region name

Your question is Top Server Configurations by Region. Start with the requirements and the three tables 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