SQL · Amazon · Medium
Consider an employee dataset split across three country-specific tables: employees_us, employees_uk, and employees_jp. Each employee table stores emp_id, name, salary, currency_code, and country_code; salaries are recorded in the local currency. A separate exchange_rates table stores currency_code, rate_to_usd, and rate_date, and may contain several rows per currency with different dates. Write one SQL statement that: Combines all rows from the three employee tables into one…
Checking your access…