CODE EXAMPLE FOR SQL

SQL

select colour, count (*) 
from   bricks
having sum ( weight ) > 1
group  by colour;