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
Investigate this case →