sandy_heron_7722
Exemplar
Top 2.2%
Member Nº 3632
Joined Jul 2026
SQL
Window Deduplication
Common Table Expressions
Inequality Joins
Python
Dict Merging
Frequency Counting
List Comprehension
Spark
Inequality Joins
Regex Functions
Catalyst Optimizer
Data Modeling
Self-Referential
Many-to-Many
One-to-One
Solved
SQL29
Python12
Milestones
Top 100
Top 4% SQL
10 solved
Solution author
970 runs in the past 26 weeksActive days: 14 · Max streak: 6
MarAprMayJunJulAugSep
Recent solves
The Bouncer
Python · easy
Given sorted_nums = [1, 4, 7, 12, 18, 23], use bisect.insort to insert 10
Python · medium · lesson
Use bisect.insort to build a sorted list from the unsorted values [5, 2, 8, 1, 9, 3]
Python · medium · lesson
Import bisect
Python · medium · lesson
Create a deque from [1, 2, 3]
Python · medium · lesson
Create a deque with maxlen=4
Python · medium · lesson
Use heapq.nsmallest and heapq.nlargest to find the 3 smallest and 3 largest values from [15, 3, 28,
Python · medium · lesson
Import heapq
Python · medium · lesson
Append "python" to the "languages" list inside the dev dictionary
Python · medium · lesson
Create a copy of base using .copy(), then use .update() to merge overrides into the copy
Python · medium · lesson