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
SQL Question
AI Insights
Quick Summary
Count users who recorded zero rides within a specific 7-day window.
Include users who have never taken any rides in their lifetime.
Return a single aggregated count representing total inactive users.
What This Tests
Filtering records by date ranges
Identifying non-matching or missing relationships between tables
Handling complete versus partial historical data
Conditional aggregation with exclusion logic
Common Patterns
Subquery
Deduplication
Aggregation
Collapse
Hint
What Interviewers May Ask Next
Accepted
50
/142
Acceptance Rate
35.2%
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
-
