azure_ember_5308
Exemplar
Top 2.2%
Member Nº 1422
Joined Jun 2026
SQL
Storage Optimization
Window Frames
Window Deduplication
Python
Two-Pointer
Nested Dicts
Frequency Counting
Spark
Window Frames
Window Deduplication
First & Last Values
Data Modeling
Self-Referential
Many-to-Many
One-to-One
Pipeline Architecture
Kappa Architecture
Lambda Architecture
SCD in Pipelines
Solved
SQL39
Python31
Spark0
Pipeline Architecture0
Milestones
Top 100
Top 3% SQL
Top 4% Python
50 solved
Hire verdict
30 active days
1,564 runs in the past 26 weeksActive days: 56 · Max streak: 16
MarAprMayJunJulAugSep
Recent solves
Round and Round They Go
Python · medium
The Listeners
Python · medium
The Event Bucketer
Python · easy
The Forward Fill
Python · easy
The Rolling Peak
Python · medium
The Window Cleaner
Python · medium
The Long Run
Python · easy
From user_sessions, return session_id and session_start cast to DATE as session_day
SQL · medium · lesson
Convert session start times to plain dates
SQL · medium · lesson
Total nested team scores with a dict comprehension
Python · medium · lesson