Netflix Country Marketing Spend

Netflix

Interview Core Track · Easy · 15 min

SELECT c.country_name, SUM(ms.amount_spent) as total_marketing_budget FROM fact_marketing_spend AS ms JOIN dimension_country AS c ON ms.country_id=c.country_...

Interview Core Track

Easy

15 min

joins

aggregation

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

Timer 00:00

Back to practice

Objective

Practice joins through a Netflix-tagged business scenario.

Approach

Use this track to improve speed, edge-case handling, and accuracy under timed conditions.

Company context

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

Prereq: query basics

Prereq: filtering

SELECT c.country_name, SUM(ms.amount_spent) as total_marketing_budget FROM fact_marketing_spend AS ms JOIN dimension_country AS c ON ms.country_id=c.country_id WHERE ms.campaign_date BETWEEN '2024-01-01' and '2024-03-31' GROUP BY c.country_name

dimension_country

country_id INTEGER

country_name TEXT

fact_marketing_spend

spend_id INTEGER

country_id INTEGER

campaign_date DATE

amount_spent NUMERIC(10

Editor

SQL workspace

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

Sign in to run SQL

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