CREATE TABLE faculty_participates_in (facid DECIMAL, actid DECIMAL)
CREATE TABLE participates_in (stuid DECIMAL, actid DECIMAL)
CREATE TABLE faculty (facid DECIMAL, lname TEXT, fname TEXT, rank TEXT, sex TEXT, phone DECIMAL, room TEXT, building TEXT)
CREATE TABLE student (stuid DECIMAL, lname TEXT, fname TEXT, age DECIMAL, sex TEXT, major DECIMAL, advisor DECIMAL, city_code TEXT)
CREATE TABLE activity (actid DECIMAL, activity_name TEXT)

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.
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
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"