simple_snail_9819
Exemplar
Top 2.2%
Member Nº 2073
Joined Jun 2026
SQL
Window Deduplication
Storage Optimization
Self-Join
Python
Recursion
Type Hints
Lambda
Spark
Multiple Windows
Catalyst Optimizer
Window Frames
Data Modeling
Constraints
Primary Keys
Data Types
Solved
Python29
SQL12
Data Modeling0
Milestones
Top 100
Top 4% Python
Strong Hire
10 solved
7-day streak
623 runs in the past 26 weeksActive days: 14 · Max streak: 7
MarAprMayJunJulAugSep
Recent solves
Count the total server log entries and compare how many have a response time recorded versus missing
SQL · medium · lesson
First Migration Record
SQL · easy · lesson
From transactions, return transaction_id, total_amount, and SUM(total_amount) OVER (ORDER BY transac
SQL · medium · lesson
Where You Stand
SQL · easy · lesson
Import heapq
Python · medium · lesson
Use a dict comprehension to invert country_codes (swap keys/values), keeping only countries with nam
Python · medium · lesson
Use heapq.nsmallest and heapq.nlargest to find the 3 smallest and 3 largest values from [15, 3, 28,
Python · medium · lesson
Ad Revenue {{YEAR}}
SQL · easy
User Age Ranking
SQL · easy · lesson
The Opening Run
SQL · easy · lesson