CREATE TABLE Services (Service_ID NUMBER, Service_Type_Code CHAR)
CREATE TABLE Events (Event_ID NUMBER, Service_ID NUMBER, Event_Details VARCHAR2)
CREATE TABLE Participants_in_Events (Event_ID NUMBER, Participant_ID NUMBER)
CREATE TABLE Participants (Participant_ID NUMBER, Participant_Type_Code CHAR, Participant_Details VARCHAR2)

How many events have each participants attended? Show their average number by each participant type code using a bar chart, sort from low to high by the names.
SELECT T1.Participant_Type_Code, AVG(COUNT(*)) FROM Participants AS T1 JOIN Participants_in_Events AS T2 ON T1.Participant_ID = T2.Participant_ID GROUP BY T1.Participant_Type_Code ORDER BY T1.Participant_Type_Code
SELECT "T1"."Participant_Type_Code", AVG(COUNT(*)) FROM "Participants" "T1" JOIN "Participants_in_Events" "T2" ON "T1"."Participant_ID" = "T2"."Participant_ID" GROUP BY "T1"."Participant_Type_Code" ORDER BY "T1"."Participant_Type_Code"