create table student ( stu_id, lname, fname, ssn, sex ) insert into student values(1, 'Burns', 'Barbra', '000-01-0001', 'F') INSERT INTO STUDENT VALUES(2, 'Cambi', 'Vinny', '000-01-0002', 'M') create table class ( cls_id, course_id, session, inst_ssn, stu_ssn ) insert into class values(1, 'X52-9272', 1, '000-02-0001', '000-01-0001') insert into class values(2, 'X52-9259', 1, '000-02-0002', '000-01-0001') insert into class values(3, 'X52-9272', 1, '000-02-0001', '000-01-0002') select * from blah select * from student select fname, lname, blah from student select cls_id, course_id, session, stu_ssn from class where cls_id=1 select * from student join class on student.ssn=class.stu_ssn select lname, fname, ssn, course_id from student join class on student.ssn=class.stu_ssn where sex='F' create table student (a,b,c) insert into blah values (1,2,3) '