sharp_zenith_9156
Exemplar
Top 2.2%
Member Nº 1821
Joined Jun 2026
SQL
Multiple WINDOWs
Storage Optimization
Ranking
Python
Variables
Arithmetic
Spark
Multiple Windows
Distribution Functions
Exploding Arrays
Data Modeling
Self-Referential
Many-to-Many
One-to-One
Solved
SQL4
Python0
Spark0
Data Modeling0
Milestones
Top 100
7-day streak
946 runs in the past 26 weeksActive days: 28 · Max streak: 14
MarAprMayJunJulAugSep
Recent solves
Number cloud costs within each provider-region combination (compound partition key) by bill_date
SQL · medium · lesson
Divide cloud costs into 4 quartiles within each provider
SQL · medium · lesson
For each transaction, show the user's total number of transactions and their total spending across a
SQL · medium · lesson
For each transaction, show the previous transaction amount for the same user (ordered by transaction
SQL · medium · lesson
The DAG the scheduler orders: top categories by units
Spark · hard · lesson
Average price of top-rated products
Spark · medium · lesson
Units per category from a join
Spark · medium · lesson
Total unit price for higher-quantity lines
Spark · medium · lesson
Units sold per product
Spark · medium · lesson
Revenue per category, in-stock only
Spark · medium · lesson