easyBigPay · joins
Show each transaction with its merchant name
The transaction feed stores only a merchant_id, but the app has to show the customer a readable merchant name.
Return transaction_id, amount and merchant_name for every transaction that has a matching merchant, ordered by transaction_id.
Schema
▸merchants
| merchant_id | INT |
| merchant_name | TEXT |
▸transactions
| transaction_id | INT |
| merchant_id | INT |
| amount | NUMERIC |
Example input
▸merchants
▸transactions
Stuck? Ask the coach for a nudge that won't give the answer away, or reveal the reference solution and a short walkthrough of why it works.