Complete the following with clause to count how many rows there are in colours:

with colour_count as (

)

 select * from colour_count;

This should return

COUNT(*)