ilyanotmaddyson
Savant
Top 0.9%
Member Nº 4899
Joined Sep 2026
SQL
Aggregate Window Fns
Common Table Expressions
Outer Joins
Python
Modules
String Formatting
Tuples
Spark
Window Deduplication
Exploding Arrays
Catalyst Optimizer
Data Modeling
Metric Additivity
Indexing
Constraints
Pipeline Architecture
SCD in Pipelines
Late-Arriving Data
Event Streaming Platforms
Solved
Python0
Milestones
Top 100
50 solutions
Top 1% SQL
100 solved
7-day streak
797 runs in the past 26 weeksActive days: 27 · Max streak: 14
MayJunJulAugSepOct
Recent solves
Stock Status
SQL · easy
Users Without Sessions
SQL · medium
Top of the Line
SQL · easy
Users Per Device Type
SQL · easy
Higher Performing Variant
SQL · easy
Auth Endpoint Callers
SQL · medium
The Merit Circle
SQL · medium
Character Position in Endpoint
SQL · easy
Users With Purchase Events
SQL · easy
Peak Hour Power Callers
SQL · medium