Complete the subquery to find all the rows in bricks with a colour where colours.minimum_bricks_needed = 2:

select * from bricks b

where b.colour in (

);

This should return

BRICK_ID COLOUR

 1 blue

 2 blue

 3 blue

 6 red

 7 red

 8 red