Complete the query below, using an inline view to find the min and max brick_id for each colour of brick:

select * from (

)

Hint: you need group by colour. Use min(brick_id) to find the minimum. The query should return the following rows (the order may be different):

COLOUR MIN(BRICK_ID) MAX(BRICK_ID) 

green 4 5 

 9 9 

red 6 8 

blue 1 3