granite_sage_8052
Exemplar
Top 2.2%
Member Nº 4065
Joined Aug 2026
SQL
Correlated Subquery
Window Deduplication
Multiple WINDOWs
Spark
Window Deduplication
Multiple Windows
Exploding Arrays
Data Modeling
Self-Referential
Many-to-Many
One-to-One
Solved
SQL72
Milestones
Top 100
Top 1% SQL
50 solved
Solution author
7-day streak
790 runs in the past 26 weeksActive days: 20 · Max streak: 9
MarAprMayJunJulAugSep
Recent solves
Cheapest Cost Per Region
SQL · easy
Format transaction dates as US-style MM/DD/YYYY strings
SQL · medium · lesson
Count transactions per month
SQL · medium · lesson
Show each user's username, transaction ID, and days between signup and transaction using DATE_DIFF
SQL · medium · lesson
Measure user tenure
SQL · medium · lesson
Calculate a 30-day return deadline for each transaction
SQL · medium · lesson
Show each deployment with its service name, deploy time, and today's date
SQL · medium · lesson
Find users who signed up on February 2, 2025
SQL · medium · lesson
Build a dynamic report header
SQL · medium · lesson
Convert session start times to plain dates
SQL · medium · lesson