Practice Google SQL Question | Real Coding Interviews | Hack2hire

NewDark mode is now available across the siteSee what's new

Question Bank Pricing Blog Forum

Quick Summary

Calculate the sum of measurements at odd and even positions within each calendar day.
Positions are defined by the chronological order of timestamps, resetting daily.
Requires assigning a rank to rows within each day followed by conditional aggregation.

What This Tests

Window functions with PARTITION BY and ORDER BY
Ranking rows within groups to establish sequence
Conditional aggregation using logical branching
Date extraction and grouping strategies
Deterministic ordering and tie-breaking considerations

Common Patterns

Window Function

Ranking

Aggregation

Groupby

Test Cases

Input

-

Output

-

Expected

-