CREATE TABLE round (round_id NUMBER, member_id NUMBER, decoration_theme CLOB, rank_in_round NUMBER)
CREATE TABLE member (member_id NUMBER, name CLOB, country CLOB, college_id NUMBER)
CREATE TABLE college (college_id NUMBER, name CLOB, leader_name CLOB, college_location CLOB)

Show the names of members and names of colleges they go to.
SELECT T2.name, T1.name FROM college AS T1 JOIN member AS T2 ON T1.college_id = T2.college_id
SELECT "T2"."name", "T1"."name" FROM "college" "T1" JOIN "member" "T2" ON "T1"."college_id" = "T2"."college_id"