zippy_crane_9100
Exemplar
Top 2.2%
Member Nº 1068
Joined May 2026
SQL
Window Deduplication
Multiple WINDOWs
Common Table Expressions
Python
Two-Pointer
List Comprehension
Guard Clauses
Spark
Window Deduplication
Multiple Windows
Regex Functions
Data Modeling
Self-Referential
Many-to-Many
One-to-One
Learned
Python151
SQL121
Milestones
Top 100
7-day streak
1,272 runs in the past 26 weeksActive days: 26 · Max streak: 7
MarAprMayJunJulAugSep
Recent solves
Write a function two_sum(nums, target) using a hash map
Python · medium · lesson
Write a function two_sum_sorted(nums, target) using two pointers on a sorted list
Python · medium · lesson
Write a function is_palindrome(s) using two pointers that checks if a string reads the same forwards
Python · medium · lesson
Given pairs = [('ada', 95), ('linus', 82), ('grace', 91), ('margaret', 78)], filter to scores >= 90
Python · medium · lesson
Given nums = [3, 1, 4, 1, 5, 9, 2, 6, 5, 3], print the number of unique values
Python · medium · lesson
Find the common elements between two lists using sets for efficient O(n) membership testing
Python · medium · lesson
Use a dictionary to count how many times each word appears in the list
Python · medium · lesson
Complete is_sorted: compare consecutive pairs, returning False if any element is greater than the ne
Python · medium · lesson
Find both the minimum and maximum of the list in a single pass using O(1) extra space
Python · medium · lesson
Find all values that appear more than once in the list
Python · medium · lesson