FROMclause, and a
WHEREclause specifying a condition. However, we now are adding in the ability to nest a
SELECTclause inside the
WHEREclause, thus creating a subquery.
Titleof all movies which have a
Ratingless than 3, and have a
mIDgreater than 103.
Titleof all movies whose
mIDis in the first subquery, but not in the second subquery. Our first subquery looks for all
Ratingis less than 3, and the second subquery looks for all
mIDs that are greater than 103.