SELECT
clause, a FROM
clause, and a WHERE
clause specifying a condition. However, we now are adding in the ability to nest a SELECT
clause inside the WHERE
clause, thus creating a subquery.Title
of all movies which have a Rating
less than 3, and have a mID
greater than 103.Title
of all movies whose mID
is in the first subquery, but not in the second subquery. Our first subquery looks for all mID
's whose Rating
is less than 3, and the second subquery looks for all mID
s that are greater than 103.