aldinaasya
Warden
Top 7.7%
Member Nº 4859
Joined Sep 2026
SQL
Row Numbering
Ranking
Aggregate Window Fns
Python
Dict Methods
Modules
Tuples
Spark
Window Deduplication
Exploding Arrays
Regex Functions
Data Modeling
Metric Additivity
Indexing
Constraints
Learned
SQL148
Milestones
Milestones unlock as you keep learning.
772 runs in the past 26 weeksActive days: 11 · Max streak: 4
MarAprMayJunJulAugSep
Recent solves
From users, return DISTINCT age_bucket, excluding rows where age_bucket IS NULL
SQL · medium
From users, return user_id, signup_date cast to DATE as signup_dt
SQL · medium
From users, return user_id and account_status, and a column is_active as BOOLEAN equal to (account_s
SQL · medium
Use TRY_CAST to safely convert the message column to INTEGER from server_logs
SQL · medium
Select log_id and cast log_timestamp to DATE
SQL · medium
Select the distinct dates from server_logs by casting log_timestamp to DATE
SQL · medium
Select transaction_id and use CAST to convert transaction_date to DATE
SQL · medium
Calculate the per-unit price by dividing total_amount by quantity
SQL · medium
Select product_name and use CAST to convert price to DECIMAL(10,2)
SQL · medium
Select product_name, price, and in_stock from products, but only where in_stock IS NOT NULL.
SQL · medium