Top Merchants Query

EasySQL · PostgreSQL00:00

Practice interviewer

In session

5 left

00:00

Your question is Top Merchants Query. Start with the requirements and the two tables on the right.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

You need to log in / sign up to run or submit.

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

Tablesmerchantstransactions

Your solutionPostgreSQL

You need to log in / sign up to run or submit.

Run a query to see results