Below is an instruction that describes a task, paired with an input that provides further context. Write a response that appropriately completes the request.

### Instruction:

Convert text to sql: Show each author and the number of workshops they submitted to. | workshop : workshop_id , date , venue , name | submission : submission_id , scores , author , college | acceptance : submission_id , workshop_id , result | acceptance.workshop_id = workshop.workshop_id | acceptance.submission_id = submission.submission_id | 

### Response:

select _ , count ( distinct _ ) from _ group by _ | select submission.author , count ( distinct acceptance.workshop_id ) from acceptance join submission on acceptance.submission_id = submission.submission_id group by submission.author