Practice SQL Question | Real Coding Interviews | Hack2hire

NewML System Design & SQL tracks just landedSee what's new

Question Bank Pricing Blog Forum

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

Accepted

35/91

Acceptance Rate38.5%

Test Cases

Input

-

Output

-

Expected

-