How many workshops did each author submit to? Return the author name and the number of workshops.
SELECT T2.Author ,  COUNT(DISTINCT T1.workshop_id) FROM acceptance AS T1 JOIN submission AS T2 ON T1.Submission_ID  =  T2.Submission_ID GROUP BY T2.Author
SELECT T2.Author ,  COUNT(DISTINCT T1.workshop_id) FROM acceptance AS T1 JOIN submission AS T2 ON T1.Submission_ID  =  T2.Submission_ID GROUP BY T2.Author
[{'Author': 'Jeff Lloyd', 'COUNT(DISTINCT T1.workshop_id)': 1}, {'Author': 'Sammy Green', 'COUNT(DISTINCT T1.workshop_id)': 2}, {'Author': 'Sherman Smith', 'COUNT(DISTINCT T1.workshop_id)': 1}, {'Author': 'Steve Niehaus', 'COUNT(DISTINCT T1.workshop_id)': 1}, {'Author': 'Steve Raible', 'COUNT(DISTINCT T1.workshop_id)': 1}]