wild_storm_5937
Exemplar
Top 2.2%
Member Nº 3040
Joined Jul 2026
SQL
Correlated Subquery
Common Table Expressions
Array Aggregation
Python
f-strings
Variables
Arithmetic
Spark
Window Deduplication
Collecting Values
Exploding Arrays
Data Modeling
Self-Referential
Many-to-Many
One-to-One
Learned
SQL171
Spark25
Python12
Pipeline Architecture2
Milestones
Top 100
7-day streak
1,168 runs in the past 26 weeksActive days: 22 · Max streak: 9
MarAprMayJunJulAugSep
Recent solves
List the product categories Spark will process
Spark · easy · lesson
Select the names of in-stock products
Spark · easy · lesson
Count products per category (your first shuffle)
Spark · easy · lesson
Capstone: revenue by order status
Spark · medium · lesson
Capstone: average line value per category
Spark · medium · lesson
Aggregate, do not collect: top rating per category
Spark · medium · lesson
Sized by config: average price per category
Spark · medium · lesson
No shuffle, no driver round-trip: line totals
Spark · medium · lesson
A pipelined narrow chain: discounted prices
Spark · medium · lesson
Parallelism by key: page views per device
Spark · medium · lesson