SELECT Author ,  College FROM submission
For each submission, show the author and their affiliated college.
SELECT Author , College FROM submission
select author , college from submission
For each submission , show the author and their affiliated college .