Routine~12min
The Wrong Currency
26 orders from US customers show currency=INR but the amounts are in USD. The 83x exchange rate was never applied — revenue from these orders is understated by ~₹1.24 crore. Singapore orders with SGD amounts are correct and should not be flagged.
Tables you'll query
customersorders
What you'll learn
Aggregations & GROUP BYJOINs