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: For each submission, show the author and their affiliated college. | 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 _ from _ | select author , college from submission