Show the names of members and names of colleges they go to.
create table member (name varchar, college_id varchar, PRIMARY KEY (name)); create table college (name varchar, college_id varchar, PRIMARY KEY (name))
select t2.name, t1.name from college as t1 join member as t2 on t1.college_id = t2.college_id