You must use the COUNT(*) and GROUP BY to achieve this. For example

SELECT *, count(*) FROM yourdb d GROUP by d.source, d.subsource

Costas