Where will I Use a Subquery in a SQL Statement?

There are 4 common places for enhancing your SQL Query with a Subquery

In a WHERE clause

As a Search Condition

In a HAVING clause

As a Search Condition

In a FROM clause

In a SELECT clause

As a Table Specification

As a Column Specification