whole_marmot_1140
Exemplar
Top 2.2%
Member Nº 1680
Joined Jun 2026
SQL
Correlated Subquery
Common Table Expressions
Inequality Joins
Python
Two-Pointer
Splitting & Joining
Copying Lists
Spark
Window Frames
Window Deduplication
Higher-Order Functions
Data Modeling
Self-Referential
Many-to-Many
One-to-One
Solved
SQL9
Python2
Spark0
Milestones
Top 100
10 solved
1,373 runs in the past 26 weeksActive days: 20 · Max streak: 5
MarAprMayJunJulAugSep
Recent solves
Single File
Python · easy
Most Recent Token Usage
SQL · easy · lesson
The List Merger
Python · easy · lesson
Put it together: for purchase events, extract the currency and the amount from the payload, keep onl
SQL · medium · lesson
Not every payload has a currency field (only some purchases do)
SQL · medium · lesson
Purchase payloads contain an items array, each item an object with sku and qty
SQL · medium · lesson
The tags column is a JSON array of strings
SQL · medium · lesson
For button_click events, the payload has a nested position object with x and y
SQL · medium · lesson
The event_data table has a JSON payload column
SQL · medium · lesson
Put it together: for each event return event_id, the tag count, and whether it is tagged 'premium' (
SQL · medium · lesson