Task: Text to Code
Input (English): SQL: SELECT activity_name , Count ( * ) FROM Activity GROUP BY activity_name
Feedback: Search number of the corresponding rows to each value of faculty id .
Output (English): SELECT T1.activity_name ,  count(*) FROM Activity AS T1 JOIN Faculty_participates_in AS T2 ON T1.actID  =  T2.actID GROUP BY T1.actID