Database: decoration_competition
Question: Show the names of members and names of colleges they go to.
SQL:
SELECT T2.Name ,  T1.Name FROM college AS T1 JOIN member AS T2 ON T1.College_ID  =  T2.College_ID