azure_wave_4473
Savant
Top 0.7%
Member Nº 2415
Joined Jun 2026
SQL
Window Deduplication
Multiple WINDOWs
Storage Optimization
Python
List Comprehension
Guard Clauses
String Methods
Spark
Window Deduplication
Higher-Order Functions
Multiple Windows
Data Modeling
4NF
BCNF
Self-Referential
Solved
SQL19
Python0
Spark0
Data Modeling0
Milestones
Top 100
Top 8% SQL
10 solved
7-day streak
2,001 runs in the past 26 weeksActive days: 19 · Max streak: 11
MarAprMayJunJulAugSep
Recent solves
Write a function two_sum_sorted(nums, target) using two pointers on a sorted list
Python · medium · lesson
The List Merger
Python · easy · lesson
Two Names on the Ledger
SQL · easy · lesson
From transactions, return transaction_id, total_amount, and SUM(total_amount) OVER (ORDER BY transac
SQL · medium · lesson
Calculate a running total of transaction amounts ordered by date.
SQL · medium · lesson
Calculate a running total of transaction amounts ordered by date
SQL · medium · lesson
Where You Stand
SQL · easy · lesson
The Quiet Middle
SQL · easy · lesson
Alert Severity
SQL · hard · lesson
User Age Ranking
SQL · easy · lesson