CREATE TABLE services (service_id NUMBER, service_type_code CLOB)
CREATE TABLE events (event_id NUMBER, service_id NUMBER, event_details CLOB)
CREATE TABLE participants_in_events (event_id NUMBER, participant_id NUMBER)
CREATE TABLE participants (participant_id NUMBER, participant_type_code CLOB, participant_details CLOB)

How many events have each participants attended? List the participant id, type and the number.
SELECT T1.participant_id, T1.participant_type_code, COUNT(*) FROM participants AS T1 JOIN participants_in_events AS T2 ON T1.participant_id = T2.participant_id GROUP BY T1.participant_id
SELECT "T1"."participant_id", "T1"."participant_type_code", COUNT(*) FROM "participants" "T1" JOIN "participants_in_events" "T2" ON "T1"."participant_id" = "T2"."participant_id" GROUP BY "T1"."participant_id"