Subquery Nested by WHERE
Subquery Nested by FROM
Subquery Nested by HAVING
Multi-Layer Nested Subquery