Japan Revenue for April

A easy SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain

SQL

Difficulty

easy

Problem

Join transactions to customers using transactions.user_id = customers.customer_id (differently-named keys but they correspond). Keep matches where country = 'Japan' AND transaction_date is in April 2026. Return SUM(quantity * total_amount) as a single total.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.