Subqueries cannot:

a$)$ Use group by or group functions

b$)$ Retrieve data from a table different from the one in the outer query

c$)$ Join tables

d$)$ Appear in select, update, delete, insert statements.