Configurable reports block (plugin)

Hi all,

Could someone help me since I am not great with SQL.

How can i build a report that counts all of the activities per category?

Something along the lines of SELECT * activities in (cat name) but obviously it is not that simple.