Nested subqueries go in your where clause. The query filters rows in the parent tables. For example, to find all the rows in colours where you have a matching brick, you could write the following.
#Oracle
#Nested_Subqueries

You can also use exists in a nested subquery. The following is the same as the previous query
#Oracle
#Nested_Subqueries_2