sirmagger
#SQL
Maven
Top 0.1%
Member Nº 5131
Joined Sep 2026
SQL
Correlated Subquery
Window Deduplication
Multiple WINDOWs
Python
Context Managers
String Formatting
File Context Manager
Spark
Window Frames
Window Deduplication
Higher-Order Functions
Data Modeling
Metric Additivity
Event Sourcing
Indexing
Pipeline Architecture
SCD in Pipelines
Late-Arriving Data
Event Streaming Platforms
Solved
Milestones
Top 10
Steward ×2
500 solved
Top 1% SQL
Hire verdict
30 active days
1,460 runs in the past 26 weeksActive days: 41 · Max streak: 23
MayJunJulAugSepOct
Recent solves
Platform Team Mobile Flags
SQL · easy
Everyone Counts
SQL · easy
Bargain Bin
SQL · easy
Log Levels
SQL · easy
The Publishing Audit
SQL · easy
Non-Trivial Fatal Errors
SQL · medium
Peak Metric Per Department
SQL · easy
Content by Specific Users
SQL · easy
Popular Categories
SQL · easy
Search Endpoint Status Distribution
SQL · easy