Practice Waymo SQL Question | Real Coding Interviews | Hack2hire

NewThe Learning module is now liveSee what's new

Question Bank Learning

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

61/229

Acceptance Rate26.6%

Test Cases

Input

-

Output

-

Expected

-