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

What is the first and last name of the faculty members who participated in at least one activity? For each of them, also show 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" "T1" JOIN "faculty_participates_in" "T2" ON "T1"."facid" = "T2"."facid" GROUP BY "T1"."facid"