timber_lake_4359
Warden
Top 7.8%
Member Nº 1737
Joined Jun 2026
SQL
Storage Optimization
Window Partitioning
Window Deduplication
Python
Dict Methods
List Modification
Type Conversion
Spark
Window Deduplication
Exploding Arrays
Catalyst Optimizer
Data Modeling
Self-Referential
Many-to-Many
One-to-One
Solved
SQL1
Python0
Milestones
First milestone at 10 problems solved.
1,090 runs in the past 26 weeksActive days: 9 · Max streak: 4
MarAprMayJunJulAugSep
Recent solves
For each user session, show the user_id, session_start, pages_viewed, and the pages_viewed from the
SQL · medium · lesson
For each transaction, show the user_id, transaction_date, total_amount, and the previous transaction
SQL · medium · lesson
For each transaction, show user_id, transaction_date, total_amount, the rank by total_amount (highes
SQL · medium · lesson
Divide employee metrics into 3 performance tiers within each department, based on metric_value from
SQL · medium · lesson
Divide all products into 4 price quartiles, with quartile 1 containing the most expensive products
SQL · medium · lesson
Calculate a running total of transaction amounts ordered by date
SQL · medium · lesson
Calculate the cumulative cost for each cloud provider ordered by billing date.
SQL · medium · lesson
Calculate the running average response time for each server ordered by timestamp
SQL · medium · lesson
Show each cloud cost entry alongside the lowest cost for that provider using MIN as a window functio
SQL · medium · lesson
For each product, show the product_name, category, price, and the name of the most expensive product
SQL · medium · lesson