CODE EXAMPLE FOR SQL

SQL

select colour, count (*) 
from   bricks
group  by colour;