1.virtualcollege>SELECT students.student_id FROM students WHERE students.ssn = '999-99-9999'; 2.virtualcollege>2 3.virtualcollege>SELECT catalog.course_id FROM catalog WHERE catalog.course_code = 'CIS-115'; 4.virtualcollege>4 5.virtualcollege>SELECT class_list.class_id FROM class_list WHERE class_list.course_id = 4; 6.virtualcollege>12 7.virtualcollege>SELECT COUNT(sit_list.student_id) FROM sit_list WHERE sit_list.class_id = 12; 8.virtualcollege>10 9.virtualcollege>select class_list.sit_limit from class_list where class_list.class_id = 12; 10.virtualcollege>16 11.virtualcollege>"SELECT COUNT(class_id) FROM sit_list WHERE student_id = 2 AND class_id = 12; 12.virtualcollege>0 13.virtualcollege>INSERT INTO sit_list VALUES (12, 2); 14.virtualcollege>insert 1234 1 15.virtualcollege>INSERT INTO registration_list (student_id, notes, time_stamp) VALUES (2, 'notes', 'Feb, 12 2003 12:23:45 UT' ); 16.virtualcollege>insert 1235 1 |