SQL SubQueries for Complex Conditional

Subqueries (also known as inner queries or nested queries) are a tool for performing operations in multiple steps.