Practice Meta SQL Question | Real Coding Interviews | Hack2hire

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

Question Bank Pricing Blog Forum

Quick Summary

Classify ad impressions into peak and off-peak periods based on their timestamps.
Compute engagement, revenue, and latency metrics grouped by these time windows.
Handle missing conversions gracefully while ensuring accurate ratio and average calculations.

What This Tests

Timestamp parsing and conditional business rule classification.
Preserving base records when joining with sparse event tables.
Conditional aggregation and NULL-safe metric computation.
Precise decimal rounding and time-difference calculations.

Common Patterns

Left Join

Aggregation

Groupby

Date Arithmetic

Test Cases

Input

-

Output

-

Expected

-