Top Merchants Query | Dataford Interview Questions

Write a query to find the top 10 merchants by transaction volume.

Use the available merchant and transaction records. Treat transaction volume as the count of transaction records associated with each merchant.

Output

Return one row per merchant with at least one transaction.
Include merchant_id, merchant_name, and transaction_volume.
Order by transaction volume descending, then merchant ID ascending for ties, and return at most 10 rows.

merchants

Column	Type	Description
merchant_idPK	INT	Unique merchant identifier
merchant_name	VARCHAR(150)	Merchant display name

transactions

Column	Type	Description
transaction_idPK	INT	Unique transaction identifier
merchant_id	INT	Merchant associated with the transaction

Your question is Top Merchants Query. Start with the requirements and the two 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.