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)

what are the event details of the services that have the type code 'Marriage', and count them by a pie chart
SELECT Event_Details, COUNT(Event_Details) FROM Events AS T1 JOIN Services AS T2 ON T1.Service_ID = T2.Service_ID WHERE T2.Service_Type_Code = 'Marriage' GROUP BY Event_Details
SELECT "Event_Details", COUNT("Event_Details") FROM "Events" "T1" JOIN "Services" "T2" ON "T1"."Service_ID" = "T2"."Service_ID" AND "T2"."Service_Type_Code" = 'Marriage' GROUP BY "Event_Details"