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
Identify users who have taken zero or one ride across all time.
Aggregate these low-frequency users by their registered city.
Ensure users with no rides are preserved in the final count.
What This Tests
Handling missing relationships using outer joins.
Multi-level aggregation and filtering (per-user then per-group).
Correctly counting occurrences while preserving unmatched records.
Data grouping and sorting techniques.
Common Patterns
Left Join
Subquery
Aggregation
Groupby
Collapse
Hint 1
Hint 2
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
-
