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

Compare the number of participants in each participant type code using a bar chart, and sort y-axis in desc order.
SELECT Participant_Type_Code, COUNT(Participant_Type_Code) FROM Participants GROUP BY Participant_Type_Code ORDER BY COUNT(Participant_Type_Code) DESC
SELECT "Participant_Type_Code", COUNT("Participant_Type_Code") FROM "Participants" GROUP BY "Participant_Type_Code" ORDER BY COUNT("Participant_Type_Code") DESC