Question: What does this query do ? SELECT * FROM movies AS m 1 WHERE release _ year = ( SELECT MIN ( release _ year

What does this query do?
SELECT * FROM movies AS m1 WHERE release_year =(
SELECT MIN(release_year) FROM movies AS m2 WHERE m2.director = m1.director );
(Make sure to read every answer before selecting!)
Selects each movie made in the first year its director was active.
Selects each director's first movie.
Selects each movie made in the last year its director was active.
Selects each directors last movie.
What does this query do ? SELECT * FROM movies AS

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!