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