Currency Conversion
ASKED IN INTERVIEWStripe
Problem Statement
Stripe processes payments globally and often needs to present totals in a unified currency for reporting. You have a table of transactions recorded in Euros (EUR).
Write an SQL query to convert all transaction amounts from EUR to USD using a fixed exchange rate of 1.10.
Rules:
- The conversion factor is: 1 EUR = 1.10 USD.
- The converted amount should be rounded to exactly 2 decimal places.
- Output columns: transaction_id, amount_eur, amount_usd.
- Results must be returned in descending order based on amount_usd.
Table Schema:
- Transactions: transaction_id, amount_eur, transaction_date.
Tests your understanding of
Basic SQL, Arithmetic and FinTech
Input Tables
Transactions
| transaction_id(INTEGER) | amount_eur(DECIMAL) |
|---|---|
| 1001 | 100 |
| 1002 | 50.5 |
| 1003 | 10 |
| 1004 | 250.75 |
| 1005 | 5 |
| 1006 | 1000 |
Expected Output
| transaction_id(INTEGER) | amount_eur(DECIMAL) | amount_usd(DECIMAL) |
|---|---|---|
| 1006 | 1000 | 1100 |
| 1004 | 250.75 | 275.83 |
| 1001 | 100 | 110 |
| 1002 | 50.5 | 55.55 |
| 1003 | 10 | 11 |
| 1005 | 5 | 5.5 |
Tags
EasyASKED IN INTERVIEWBasic SQLArithmeticFinTech
5 min
91%