chookolomo
Exemplar
Top 2.2%
Member Nº 1858
Joined Jun 2026
SQL
Window Deduplication
Common Table Expressions
Storage Optimization
Python
Modules
Iteration
Boolean Operators
Spark
Window Deduplication
Multiple Windows
Inequality Joins
Data Modeling
Metric Additivity
Indexing
Constraints
Solved
SQL10
Milestones
10 solved
Solution author
1,148 runs in the past 26 weeksActive days: 20 · Max streak: 4
MarAprMayJunJulAugSep
Recent solves
Session Logins Dec 13 to 19
SQL · easy
Service Alert Frequency
SQL · easy · lesson
Alert Severity
SQL · hard · lesson
User Age Ranking
SQL · easy · lesson
The Opening Run
SQL · easy · lesson
Most Recent Token Usage
SQL · easy · lesson
Average Watch Time by Format
SQL · medium
Union the usernames from users with account_status 'active' and the user_ids cast to varchar from tr
SQL · medium · lesson
Return user_id and username from users where user_id is in the set of user_ids that appear in transa
SQL · medium · lesson
Using a CTE named big_spenders that selects user_id and SUM(total_amount) AS total from transactions
SQL · medium · lesson