When an SQL SELECT command has a subquery within it $$

all predicates in the main query's WHERE clause are passed down to the subquery

there is just one SELECT clause in the entire command, including the subquery

the subquery is executed first

all predicates in the subquery's WHERE clause are passed back to the main query

the subquery is executed last