Description
Show movies released in or after 2020 with their director names.
Mission:Your studio team wants a report of recent films and their directors.
Investigation:Which movies from 2020 onward and their director names should be reported?
Expected Outcome:Movie title paired with director name for recent releases.
Concept tags:
#JOIN#WHERE
Estimated: 4 minDifficulty: Intermediate
Database Schema
Relationships
movies.director_iddirectors.id
Tables
directors
idname
movies
idtitleyearratingdirector_id
Monaco SQL EditorIntermediate4m
Loading...
SCAN
FILTER
GROUP
SORT
RESULT
Pipeline elapsed: 0ms
Shortcuts: Ctrl/Cmd+Enter run, Ctrl/Cmd+/ comment, Ctrl/Cmd+Shift+F format
#JOIN#WHERE
Result Summary
Expected: 3
Actual: 0
Needs update
Smart Hint: You returned fewer rows. Check JOIN/WHERE.
Progressive Hints
Hint 1: Start with movies aliased as m and directors aliased as d.
movies.director_iddirectors.id
Run a query to see results.
Tip: Explore table previews first to understand data relationships.