New
ML System Design & SQL tracks just landed
See what's new
×
Question Bank
Pricing
Blog
Forum
HOT
JobRadar
NEW
Referral
Description
Solution
Discussion
Submissions
Ask AI
Question Bank
Waymo
SQL Question
AI Insights
Quick Summary
Group ride records by their calendar month to compute monthly metrics.
Calculate the total ride count and average rating per month while ignoring missing values.
Format the output as YYYY-MM and sort results from most recent to oldest.
What This Tests
Extracting and grouping dates by year-month buckets.
Handling NULL values within aggregate calculations.
Ordering grouped results in descending order.
Identifying and ignoring irrelevant schema tables.
Common Patterns
Aggregation
Sort
Collapse
Hint
What Interviewers May Ask Next
Ask AI Assistant
Ask AI Assistant
Ask me anything about this coding question!
Qwen
Qwen3.6-Flash
0/2000
Run
Submit
Test Cases
SQL Schema
Pandas Schema
Input
-
Output
-
Expected
-
