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