CREATE TABLE Acceptance (Submission_ID NUMBER, Workshop_ID NUMBER, Result CLOB)
CREATE TABLE workshop (Workshop_ID NUMBER, Date CLOB, Venue CLOB, Name CLOB)
CREATE TABLE submission (Submission_ID NUMBER, Scores FLOAT, Author CLOB, College CLOB)

Pie. how many workshops did each author submit to? Return the author name and the number of workshops.
SELECT Author, COUNT(DISTINCT T1.Workshop_ID) FROM Acceptance AS T1 JOIN submission AS T2 ON T1.Submission_ID = T2.Submission_ID
SELECT "Author", COUNT(DISTINCT "T1"."Workshop_ID") FROM "Acceptance" "T1" JOIN "submission" "T2" ON "T1"."Submission_ID" = "T2"."Submission_ID"