gentle_frog_6617
Savant
Top 0.9%
Member Nº 2713
Joined Jul 2026
SQL
Window Deduplication
Common Table Expressions
Correlated Subquery
Python
Type Hints
Stack & Queue
Dict Methods
Spark
Window Deduplication
Higher-Order Functions
First & Last Values
Data Modeling
Indexing
Grain Definition
Event Sourcing
Pipeline Architecture
Late-Arriving Data
SCD in Pipelines
Micro-Batch vs True Streaming
Solved
Pipeline Architecture0
Milestones
Top 100
Steward ×2
Top 1% SQL
Top 1% Python
Top 3% Data Modeling
100 solved
1,268 runs in the past 26 weeksActive days: 77 · Max streak: 18
MayJunJulAugSepOct
Recent solves
Anti-Join: Intermediate
SQL · medium · lesson
Anti-Join: Intermediate
SQL · medium · lesson
Anti-Join: Intermediate
SQL · medium · lesson
Anti-Join: Intermediate
SQL · medium · lesson
Deduplication: Intermediate
SQL · medium · lesson
Deduplication: Intermediate
SQL · medium · lesson
Two Pointers: Beginner
Python · easy · lesson
Top 2 Ad Campaigns by Spend
SQL · medium
Top 2 Callers per Endpoint
SQL · medium
Group Average
Python · hard