SQL Joins and Task Prioritization | Dataford Interview Questions

Write a SQL query involving joins across movie and culture-related tables, and explain how you would prioritize the tasks needed to answer the question.

Use the provided tables to identify 2023 movies with named cultural associations. Exclude associations whose culture name is NULL and explain the order in which you would validate requirements, joins, filters, aggregation, and output.

Output

One row per qualifying movie with movie_title, culture_count, and alphabetically ordered cultures
Include only movies released in 2023 with at least one named culture
Sort by culture_count descending, then movie_title ascending

Schema

movies

Column	Type	Description
movie_idPK	INT	Unique movie identifier
movie_title	VARCHAR(200)	Movie title
release_year	INT	Original release year
genre	VARCHAR(80)	Primary movie genre

movie_cultures

Column	Type	Description
movie_culture_idPK	INT	Unique movie-culture association identifier
movie_id	INT	Referenced movie identifier
culture_id	INT	Referenced culture identifier

cultures

Column	Type	Description
culture_idPK	INT	Unique culture identifier
culture_name	VARCHAR(100)	Display name of the culture
region	VARCHAR(100)	Broad geographic region

Your question is SQL Joins and Task Prioritization. Start with the requirements and the three tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem