shparky

Warden

Top 8.4%

Member Nº 5036

Joined Oct 2026

SQL

Common Table Expressions

Window Deduplication

Self-Join

Python

Modules

Iteration

Strings

Spark

Window Deduplication

Distribution Functions

Catalyst Optimizer

Data Modeling

Metric Additivity

Surrogate Keys

Indexing

Pipeline Architecture

Medallion Architecture

ELT vs ETL

Data Lake Architecture

Solved

Data Modeling0

Pipeline Architecture0

Milestones

First in

10 solved

7-day streak

First interview

189 runs in the past 26 weeksActive days: 18 · Max streak: 10

AprMayJunJulAugSepOct

Recent solves

Query Structure: Intermediate

SQL · medium · lesson

Query Structure: Intermediate

SQL · medium · lesson

Query Structure: Intermediate

SQL · medium · lesson

Query Structure: Intermediate, ORDER BY and LIMIT Challenge 2

SQL · easy · lesson

Query Structure: Intermediate, ORDER BY and LIMIT Challenge 1

SQL · easy · lesson

Query Structure: Intermediate, ORDER BY and LIMIT Challenge 3

SQL · easy · lesson

Query Structure: Intermediate, UNION and UNION ALL Challenge 2

SQL · medium · lesson

Query Structure: Intermediate, UNION and UNION ALL Challenge 1

SQL · easy · lesson

Query Structure: Intermediate, Subqueries for temp results Challenge 2

SQL · medium · lesson

Query Structure: Intermediate, Subqueries for temp results Challenge 1

SQL · medium · lesson