CREATE TABLE student (fname VARCHAR2, lname VARCHAR2, stuid VARCHAR2, major VARCHAR2)
CREATE TABLE member_of_club (clubid VARCHAR2, stuid VARCHAR2)
CREATE TABLE club (clubid VARCHAR2, clubname VARCHAR2)

Find all members of 'Bootup Baltimore' whose major is '600'. Show the first name and last name.
SELECT t3.fname, t3.lname FROM club AS t1 JOIN member_of_club AS t2 ON t1.clubid = t2.clubid JOIN student AS t3 ON t2.stuid = t3.stuid WHERE t1.clubname = "Bootup Baltimore" AND t3.major = "600"
SELECT "t3"."fname", "t3"."lname" FROM "club" "t1" JOIN "member_of_club" "t2" ON "t1"."clubid" = "t2"."clubid" JOIN "student" "t3" ON "600" = "t3"."major" AND "t2"."stuid" = "t3"."stuid" WHERE "Bootup Baltimore" = "t1"."clubname"