Put it together: for purchase events, extract the currency and the amount from the payload, keep onl

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

Domain

SQL

Difficulty

medium

Problem

Put it together: for purchase events, extract the currency and the amount from the payload, keep only purchases with amount >= 100, then return each currency with the count of such purchases. Columns: currency, big_purchase_count. Order by big_purchase_count descending then currency ascending.

Practice This Problem

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