Practice SQL Question | Real Coding Interviews | Hack2hire

NewThe Learning module is now liveSee what's new

Question Bank Learning

Pricing Blog Forum

Quick Summary

Combine pre-aggregated historical play counts with individual weekly listening events.
Filter new events to a specific cutoff date and treat each event as a single play.
Aggregate totals per user-song pair and sort results by descending play count.

What This Tests

Combining datasets with different granularities into a unified record set.
Applying temporal filters to isolate relevant time periods.
Rolling up counts across combined records using aggregation.
Ordering output based on computed aggregate values.

Common Patterns

Union

Aggregation

Groupby

Sort

Accepted

9/17

Acceptance Rate52.9%

Test Cases

Input

-

Output

-

Expected

-