Objectives The goal of the assignment is to get you to think about subqueries. This assignment focuses on how to write a subquery, use the IN operator when writing a subquery, use comparison operators when writing a subquery, write a correlated subquery including the use of the EXISTS operator, and use the ORDER BY clause when writing a subquery This assignment reinforces the following objectives: learn the formal subquery definition and write a subquery. learn the subquery restrictions. use the IN operator when writing a subquery. nest subqueries at multiple levels. use comparison operators when writing a subquery use the ALL and ANY keywords when writing a subquery write a correlated subquery including the use of the EXISTS operator use the ORDER BY clause when writing a subquery