SQL Top Three Clients | Dataford Interview Questions

Write a basic SQL query to find the top three spending clients from a transaction database.

Use the transactions table and return one row per named client. Exclude transactions that do not identify a client.

Output

transactions

Column	Type	Description
transaction_idPK	INT	Unique transaction identifier
client_name	VARCHAR(150)	Name of the client associated with the transaction
amount	DECIMAL(12,2)	Transaction amount
transaction_date	DATE	Date the transaction occurred

Your question is SQL Top Three Clients. 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.

Write a basic SQL query to find the top three spending clients from a transaction database.

Use the transactions table and return one row per named client. Exclude transactions that do not identify a client.

transactions

Column	Type	Description
transaction_idPK	INT	Unique transaction identifier
client_name	VARCHAR(150)	Name of the client associated with the transaction
amount	DECIMAL(12,2)	Transaction amount
transaction_date	DATE	Date the transaction occurred

Your question is SQL Top Three Clients. 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.