CODE EXAMPLE FOR SQL

SQL

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