Database: workshop_paper
Question: For each submission, show the author and their affiliated college.
SQL:
SELECT Author ,  College FROM submission