Table Schema
Inspect
Table
| Column | Type |
|---|---|
| txn_id | integer |
| merchant_id | varchar |
| amount | integer |
Merchant
Revenue
Find the top 2 merchants by total transaction amount.
Inspect
Sample Data
Input
Output
Sample Input: transactions
| txn_id | merchant_id | amount |
|---|---|---|
| 1 | M1 | 100 |
| 2 | M2 | 200 |
| 3 | M1 | 300 |
| 4 | M3 | 400 |
| 5 | M2 | 150 |
| 6 | M1 | 250 |
Expected Output
| merchant_id | total_amount |
|---|---|
| M1 | 650 |
| M3 | 400 |
SQL Editor
Run
Query
Waiting for query
| merchant_id | total_amount |
|---|---|
| M1 | 650 |
| M3 | 400 |
Hints
Unlock
Clues
Hint 01: Revenue is the sum of amount.
Hint 02: Aggregate by merchant_id.
Hint 03: Sort high to low and limit to 2.
Solution
Locked
Answer
Solution is locked until you decide to reveal it. Try the editor first, then open this when you want the reference answer.
SELECT merchant_id, SUM(amount) AS total_amount FROM transactions GROUP BY merchant_id ORDER BY total_amount DESC LIMIT 2;
Explanation
Step By
Step
01
Group transactions by merchant.
02
Sum the amount for each merchant.
03
Return the two highest totals.
Related Questions