iron_haven_6167
Exemplar
Top 2.2%
Member Nº 1761
Joined Jun 2026
SQL
Window Deduplication
Common Table Expressions
Storage Optimization
Python
Two-Pointer
Conditionals
Variables
Spark
Window Deduplication
Inequality Joins
Exploding Arrays
Data Modeling
Self-Referential
Many-to-Many
One-to-One
Solved
SQL5
Python0
Milestones
Top 100
1,152 runs in the past 26 weeksActive days: 16 · Max streak: 5
MarAprMayJunJulAugSep
Recent solves
Use the two-pointer technique to find if two numbers sum to 12
Python · medium · lesson
Write a function is_palindrome(s) using two pointers (left and right) that checks if a string reads
Python · medium · lesson
Most Recent Token Usage
SQL · easy · lesson
From server_logs, return log_id and CAST(log_timestamp AS DATE) AS log_day
SQL · medium · lesson
From server_logs, return server_name and LENGTH(message) AS msg_len
SQL · medium · lesson
From server_logs, return log_id, response_time_ms, and CAST(response_time_ms AS DOUBLE) AS ms_double
SQL · medium · lesson
Build a product summary string with CONCAT and CAST
SQL · medium · lesson
Show products with price and stock status cast to text, and rating cast to integer, limited to 3 row
SQL · medium · lesson
Select each product's ID, price cast as a whole number, and rating cast as text
SQL · medium · lesson
Split each user's email into local part and domain using SUBSTR and STRPOS
SQL · medium · lesson