CREATE TABLE Participants (Participant_ID NUMBER, Participant_Type_Code CHAR, Participant_Details VARCHAR2)
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)

Bar chart x axis event details y axis how many event details
SELECT Event_Details, COUNT(Event_Details) FROM Events GROUP BY Event_Details
SELECT "Event_Details", COUNT("Event_Details") FROM "Events" GROUP BY "Event_Details"