Quick Overview

Practice SQL for music playback analytics by finding top tracks globally and top tracks per country from event logs. The prompt targets aggregation, window functions, tie behavior, deterministic ordering, and dashboard-oriented performance considerations.

Query Top Played Tracks Globally And By Country

Company: Spotify

Role: Machine Learning Engineer

Category: Data Manipulation (SQL/Python)

Difficulty: easy

Interview Round: Technical Screen

Overview: Practice SQL for music playback analytics by finding top tracks globally and top tracks per country from event logs. The prompt targets aggregation, window functions, tie behavior, deterministic ordering, and dashboard-oriented performance considerations.

Loading…