Complete the scalar subquery below to find the minimum brick_id for each colour:

select c.colour_name, (

 ) min_brick_id

from colours c

where c.colour_name is not null;

The query should return the following rows:

COLOUR_NAME MIN_BRICK_ID 

green 4 

red 6 

blue 1 

purple 

yellow  

orange