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 m WHERE runtime
SELECT MINruntime FROM movies AS m WHERE mgenre mgenre ;
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.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
