0% Completed

Select all movies

BeginnerDB: movies_v1

Description

List all movie titles with their release year.

Mission:You are helping a streaming platform audit its movie catalog.

Investigation:Which movie titles and release years exist in the catalog?

Expected Outcome:A complete list of movie titles and years.

Concept tags:

#SELECT#Columns

Estimated: 2 minDifficulty: Beginner

Database Schema

Relationships

movies.director_iddirectors.id

Tables

directors

idname

movies

idtitleyearratingdirector_id

Monaco SQL EditorBeginner2m

SCAN

FILTER

GROUP

SORT

RESULT

Pipeline elapsed: 0ms

Shortcuts: Ctrl/Cmd+Enter run, Ctrl/Cmd+/ comment, Ctrl/Cmd+Shift+F format

#SELECT#Columns

Result Summary

Expected: 7

Actual: 0

Needs update

Smart Hint: You returned fewer rows. Check JOIN/WHERE.

Progressive Hints

Hint 1: Start from the movies table.

movies.director_iddirectors.id

Run a query to see results.

Tip: Explore table previews first to understand data relationships.