title: SQL Count using two people
body: <p>I'm trying to figure out from the past two days how to perform an count function on the following query: For each module, list the module title and the number of activities scheduled for the module. 
  My two tables that are needed for this are :
  TblActivity - ID,  Name, Type, ModuleID,  Day, Time, RoomID. 
  TblModule - ID, Title
  I'm sure GROUP BY needs to be used as well but I don't know how to implement it. I'm using SQL server management studio 2008. 
  Thank you. </p>