Apple Multimedia Active Users

Foundations Track · Easy · 15 min

SELECT COUNT(distinct user_id) as distinct_user_count FROM fct_multimedia_usage WHERE usage_date='2024-07-31'

Foundations Track

Easy

15 min

aggregation

filtering

Company labels are directional practice context, not official interview guidance.

Timer 00:00

Practice aggregation through a Apple-tagged business scenario.

Use this track to lock in clean query structure, basic filtering logic, and confidence with grouped output.

Company labels are directional practice context, not official interview guidance.

Prereq: query basics

Prereq: filtering

SELECT COUNT(distinct user_id) as distinct_user_count FROM fct_multimedia_usage WHERE usage_date='2024-07-31'

usage_id INTEGER

user_id INTEGER

usage_date DATE

content_type TEXT

duration_seconds INTEGER

device_type TEXT

Editor

Run queries against the protected question data, then submit once the result shape looks right.

Create a free account or sign in before running queries against protected question data.