How many author are in the workshop altogether
select count ( distinct author ) from submission
Give me the names of all the authors.
select distinct author from submission
How many workshops did each author submitted to
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