Database: activity_1
Question: Show the first and last name of all the faculty members who participated in some activity, together with the number of activities they participated in.
SQL:
SELECT  T1.fname ,  T1.lname ,  count(*) ,  T1.FacID FROM Faculty AS T1 JOIN Faculty_participates_in AS T2 ON T1.facID  =  T2.facID GROUP BY T1.FacID