Question: What does this query do ? SELECT * FROM movies AS m 1 WHERE runtime > = SELECT MIN ( runtime ) FROM movies AS

What does this query do?
SELECT * FROM movies AS m1 WHERE runtime >=
SELECT MIN(runtime) FROM movies AS m2 WHERE m2.genre = m1.genre );
Selects every movie whose genre's minimum runtime is bigger than the movie's runtime.
Selects every movie whose genre has the shortest minimum runtime.
Selects every movie whose runtime is bigger than every other movie in its genre.
Selects every movie.
Selects every movie whose genre's minimum runtime is bigger than or equal to the movie's runtime.
Selects every movie whose genre is the same as the shortest 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!