rapid_pond_6738
Exemplar
Top 2.2%
Member Nº 1213
Joined May 2026
SQL
String Building
Date Differences
Type Casting
Python
Modules
Tuples
List Modification
Spark
Catalyst Optimizer
Salting Strategy
Distributed Primitives
Data Modeling
Self-Referential
Many-to-Many
Metric Additivity
Learned
Python95
SQL89
Milestones
Top 100
754 runs in the past 26 weeksActive days: 16 · Max streak: 3
MarAprMayJunJulAugSep
Recent solves
From user_sessions, count how many sessions started in the year 2024 as total_2024
SQL · medium · lesson
From user_sessions, return session_id, session_start, and session_start plus 7 days as one_week_late
SQL · medium · lesson
From user_sessions, return session_id and session_start cast to DATE as session_day
SQL · medium · lesson
Find users who signed up more than 6 months ago
SQL · medium · lesson
Measure user tenure
SQL · medium · lesson
For each user, find the date 3 months before their signup
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