SQL> set linesize 140 SQL> set pagesize 60 SQL> select students.studentid, last, first, dept, course 2 from students, enrollments, sections 3 where enrollments.studentid = students.studentid and 4 enrollments.sectionid = sections.sectionid; STUD LAST FIRST DEPT COU ---- --------------- --------------- ---- --- 5555 Hardaway Penny CSC 157 1119 Camby Marcus CSC 157 1113 Anderson Kenny CSC 151 1117 Hill Grant CSC 151 1123 Bradley Shawn CSC 151 5555 Hardaway Penny CSC 151 1093 Webber Chris CHEM 111 1111 Barkley Charles CHEM 111 1113 Anderson Kenny CHEM 111 1116 Iverson Allen CHEM 111 1123 Bradley Shawn CHEM 111 5555 Hardaway Penny CHEM 111 1111 Barkley Charles CSC 151 1116 Iverson Allen CSC 151 1123 Bradley Shawn CSC 151 5555 Hardaway Penny CSC 151 1093 Webber Chris CSC 151 1115 O'Neal Shaq CSC 151 1113 Anderson Kenny CSC 151 1115 O'Neal Shaq CSC 151 1119 Camby Marcus CSC 151 1011 Kidd Ason CSC 152 1093 Webber Chris CSC 152 1111 Barkley Charles CSC 152 1115 O'Neal Shaq CSC 152 1116 Iverson Allen CSC 152 1119 Camby Marcus CSC 152 2121 Van Horn Keith CSC 152 1123 Bradley Shawn CSC 265 1117 Hill Grant CSIT 447 1117 Hill Grant CSIT 365 1123 Bradley Shawn CSIT 136 1093 Webber Chris CSIT 136 5555 Hardaway Penny CSIT 136 5555 Hardaway Penny CSIT 461 1119 Camby Marcus CSC 151 1113 Anderson Kenny CSC 151 1115 O'Neal Shaq CSC 151 7070 Duncan Tim CSC 151 1011 Kidd Ason CSC 151 1111 Barkley Charles CSC 151 1212 Bryant Kobe CSC 152 2222 Hughes Larry CSC 152 1818 Garnett Kevin CSC 152 3131 Battier Shane CSC 152 7171 Pierce Paul CSC 152 1123 Bradley Shawn CSC 157 2121 Van Horn Keith CSC 157 6161 Jordan Michael CSC 157 1093 Webber Chris CSC 162 5555 Hardaway Penny CSC 162 1123 Bradley Shawn CSC 264 1093 Webber Chris CSC 264 1117 Hill Grant CSC 372 1117 Hill Grant CSC 480 1119 Camby Marcus BIO 180 1818 Garnett Kevin BIO 180 STUD LAST FIRST DEPT COU ---- --------------- --------------- ---- --- 3131 Battier Shane BIO 180 1116 Iverson Allen BIO 210 1212 Bryant Kobe BIO 210 2222 Hughes Larry BIO 210 5151 Davis Baron BIO 210 7171 Pierce Paul BIO 210 1818 Garnett Kevin CHEM 111 2222 Hughes Larry CHEM 111 1116 Iverson Allen CHEM 201 1119 Camby Marcus CHEM 201 1212 Bryant Kobe CHEM 201 5151 Davis Baron CHEM 201 3131 Battier Shane CHEM 111 7171 Pierce Paul CHEM 201 1011 Kidd Ason MGMT 302 1113 Anderson Kenny MGMT 302 1115 O'Neal Shaq MGMT 302 6161 Jordan Michael MGMT 302 2121 Van Horn Keith MGMT 354 2121 Van Horn Keith MGMT 353 6161 Jordan Michael MKTG 305 1115 O'Neal Shaq MKTG 301 6161 Jordan Michael MKTG 301 1111 Barkley Charles ECN 150 1115 O'Neal Shaq ECN 150 3131 Battier Shane ECN 150 5555 Hardaway Penny ECN 150 4141 Robinson Glenn ECN 213 1093 Webber Chris ECN 155 1113 Anderson Kenny ECN 155 1111 Barkley Charles ENG 107 1123 Bradley Shawn ENG 107 5555 Hardaway Penny ENG 108 1113 Anderson Kenny ENG 150 1115 O'Neal Shaq ENG 150 5151 Davis Baron ENG 150 1818 Garnett Kevin ENG 107 1119 Camby Marcus ENG 150 1212 Bryant Kobe ENG 150 1116 Iverson Allen ENG 150 2222 Hughes Larry ENG 150 7171 Pierce Paul ENG 150 7070 Duncan Tim ENG 203 3131 Battier Shane ENG 107 1113 Anderson Kenny MTH 117 1115 O'Neal Shaq MTH 117 1116 Iverson Allen MTH 117 5151 Davis Baron MTH 120 1818 Garnett Kevin MTH 113 1119 Camby Marcus MTH 120 1123 Bradley Shawn MTH 120 1212 Bryant Kobe MTH 120 1117 Hill Grant MTH 240 1093 Webber Chris MTH 140 5555 Hardaway Penny MTH 140 7171 Pierce Paul MTH 221 1123 Bradley Shawn PSY 155 STUD LAST FIRST DEPT COU ---- --------------- --------------- ---- --- 1212 Bryant Kobe PSY 155 4141 Robinson Glenn PSY 155 1011 Kidd Ason REL 150 1119 Camby Marcus REL 153 2121 Van Horn Keith REL 153 5555 Hardaway Penny REL 153 1818 Garnett Kevin REL 153 5151 Davis Baron REL 153 6161 Jordan Michael REL 153 1116 Iverson Allen HIS 305 1111 Barkley Charles HIS 151 4141 Robinson Glenn HIS 329 7070 Duncan Tim HIS 329 4141 Robinson Glenn HIS 333 7070 Duncan Tim HIS 333 1123 Bradley Shawn HIS 151 2222 Hughes Larry HIS 151 4141 Robinson Glenn HIS 324 7070 Duncan Tim HIS 324 1117 Hill Grant POL 151 1116 Iverson Allen POL 151 1115 O'Neal Shaq BUS 200 1117 Hill Grant BUS 200 1011 Kidd Ason BUS 150 2121 Van Horn Keith CSIT 362 1117 Hill Grant CSD 340 140 rows selected. SQL> SQL> SQL> SQL> SQL> REM list for particular section SQL> select students.studentid, last, first, dept, course 2 from students, enrollments, sections 3 where enrollments.studentid = students.studentid and 4 enrollments.sectionid = sections.sectionid 5 and sections.sectionid = '66419'; STUD LAST FIRST DEPT COU ---- --------------- --------------- ---- --- 1011 Kidd Ason CSC 152 1093 Webber Chris CSC 152 1111 Barkley Charles CSC 152 1115 O'Neal Shaq CSC 152 1116 Iverson Allen CSC 152 1119 Camby Marcus CSC 152 2121 Van Horn Keith CSC 152 7 rows selected. SQL> SQL> SQL> SQL> REM can use not equal SQL> Select time, room, stoppoint from sections 2 Where room <> 'O 129'; TIME ROOM STOPPOINT -------- -------- ---------- MWF 930 O 111 25 MWF 1130 O 107 25 MWF 1230 O 107 25 mw610 bs117 25 mw900 at123 99 mw120 bs134 35 tt200 bs134 35 mw610 at123 35 mw730 bs117 35 tt610 at123 35 mw610 fa229 35 mw610 fa221 30 mw120 fa229 35 tt1230 at205 35 tt740 at123 35 mw420 bs115 30 MWF8 O 200 20 MWF9 O 127 20 MWF10 O 200 20 MWF11 O 200 20 MWF12 O 200 20 MWF11 H 101 20 MWF12 H 101 20 MWF11R11 O 219 25 MWF12R2 O 217 25 MWF9 O 109 25 MWF10 O 215 25 R6 O 201 25 T6 O 200 25 MWF11 O 113 25 MWF11 O 109 25 MW2 O 200 25 MW3:30 O 201 25 MWF10 O 217 25 MWF9 O 325 25 MWF11 O 113 25 MWF12 O 123 25 MWF10 O 113 25 TR9 O 113 25 MWF9 O 325 25 MWF11 O 113 25 MWF10 O 217 25 TR2 O 113 25 MWF11 O 325 25 MWF12 O 123 25 MWF2 C 202 25 MWF9 C 203 25 MWF11 C 202 25 MWF10 C 203 25 TR9 C 206 25 TR3:30 C 202 25 MWF10 C 203 25 MWF11 C 206 25 MWF9 C 202 25 MWF12 C 203 25 MWF2 C 203 25 MWF10 C 203 25 TIME ROOM STOPPOINT -------- -------- ---------- MWF9 C 202 25 MWF11 C 202 25 MWF10 C 203 25 MWF12 C 206 25 MWF9 C 202 25 MWF10 C 203 25 TR9 C 206 25 MWF10 C 202 25 MWF9 C 203 25 MWF11 O 113 25 MWF10 O 325 25 TR2 O 325 25 MWF9 O 217 25 MWF11 O 113 25 TR2 O 113 25 MWF2 O 113 25 MWF9 O 113 25 MWF10 O 217 25 MWF11 O 325 25 TR3:30 O 113 25 MWF9 O 113 25 MWF10 O 217 25 MWF9 O 217 25 MWF12 O 123 25 MWF11 O 113 25 MWF2 O 325 25 MWF9 O 325 25 MWF10 O 113 25 TR9 O 217 25 MWF9 O 217 25 MWF11 O 123 25 MWF12 O 113 25 MWF10 O 113 25 MWF9 O 217 25 TR2 O 113 25 MWF12 O 217 25 MWF9 O 113 25 TR2 O 113 25 TR9 O 113 25 MWF9 O 107 25 MWF10 O 107 25 MWF11 O 107 25 MWF12 O 107 25 MWF9 O 109 25 MWF10 O 109 25 MWF11 O 109 25 TR3:30 O 109 25 MWF9 O 217 25 MWF11 O 123 25 TR9 O 113 25 TR9 O 111 25 MWF9 O 111 25 MWF10 O 111 25 MWF11 O 123 25 MWF9 O 113 25 MWF10 O 217 25 MWF11 O 111 25 TIME ROOM STOPPOINT -------- -------- ---------- MWF12 O 111 25 TR9 O 113 25 MWF9 O 113 25 MWF10 O 113 25 TR2 O 217 25 MWF9 O 113 25 MWF10 O 113 25 MWF9 O 217 25 MWF12 O 113 25 MWF10 O 325 25 MWF11 O 113 25 MWF9 O 113 25 MWF10 O 113 25 MWF12 O 113 25 MWF9 O 217 25 MWF10 O 113 25 TR9 O 113 25 MWF9 O 325 25 MWF11 O 113 25 MWF10 O 113 25 MWF2 O 113 25 MWF9 O 325 25 MWF10 O 217 25 MWF11 O 123 25 TR2 O 113 25 MWF9 O 113 25 MWF10 O 113 25 MWF12 O 217 25 TR9 O 113 25 MWF9 O 113 25 MWF11 O 113 25 MWF10 O 113 25 MWF12 O 325 25 MWF11 O 113 25 MWF9 C 203 25 MWF11 O 113 25 MWF9 C 203 25 MWF12 O 113 25 MWF9 C 203 25 MWF11 O 113 25 MWF10 C 203 25 TR11 O 127 20 TR2 O 127 20 MW2 O 127 20 MWF12 O 107 25 T2 H 102 25 M6 H 102 25 161 rows selected. SQL> Select time, room, stoppoint from sections 2 Where room = 'O 129'; TIME ROOM STOPPOINT -------- -------- ---------- MWF9 O 129 20 MW3:30 O 129 20 M6 O 129 20 SQL> Select time, room, stoppoint from sections; TIME ROOM STOPPOINT -------- -------- ---------- MWF 930 O 111 25 MWF 1130 O 107 25 MWF 1230 O 107 25 mw610 bs117 25 mw900 at123 99 mw120 bs134 35 tt200 bs134 35 mw610 at123 35 mw730 bs117 35 tt610 at123 35 mw610 fa229 35 mw610 fa221 30 mw120 fa229 35 tt1230 at205 35 tt740 at123 35 mw420 bs115 30 MWF8 O 200 20 MWF9 O 127 20 MWF10 O 200 20 MWF11 O 200 20 MWF12 O 200 20 MWF11 H 101 20 MWF12 H 101 20 MWF11R11 O 219 25 MWF12R2 O 217 25 MWF9 O 109 25 MWF10 O 215 25 R6 O 201 25 T6 O 200 25 MWF11 O 113 25 MWF11 O 109 25 MW2 O 200 25 MW3:30 O 201 25 MWF10 O 217 25 MWF9 O 325 25 MWF11 O 113 25 MWF12 O 123 25 MWF10 O 113 25 TR9 O 113 25 MWF9 O 325 25 MWF11 O 113 25 MWF10 O 217 25 TR2 O 113 25 MWF11 O 325 25 MWF12 O 123 25 MWF2 C 202 25 MWF9 C 203 25 MWF11 C 202 25 MWF10 C 203 25 TR9 C 206 25 TR3:30 C 202 25 MWF10 C 203 25 MWF11 C 206 25 MWF9 C 202 25 MWF12 C 203 25 MWF2 C 203 25 MWF10 C 203 25 TIME ROOM STOPPOINT -------- -------- ---------- MWF9 C 202 25 MWF11 C 202 25 MWF10 C 203 25 MWF12 C 206 25 MWF9 C 202 25 MWF10 C 203 25 TR9 C 206 25 MWF10 C 202 25 MWF9 C 203 25 MWF11 O 113 25 MWF10 O 325 25 TR2 O 325 25 MWF9 O 217 25 MWF11 O 113 25 TR2 O 113 25 MWF2 O 113 25 MWF9 O 113 25 MWF10 O 217 25 MWF11 O 325 25 TR3:30 O 113 25 MWF9 O 113 25 MWF10 O 217 25 MWF9 O 217 25 MWF12 O 123 25 MWF11 O 113 25 MWF2 O 325 25 MWF9 O 325 25 MWF10 O 113 25 TR9 O 217 25 MWF9 O 217 25 MWF11 O 123 25 MWF12 O 113 25 MWF10 O 113 25 MWF9 O 217 25 TR2 O 113 25 MWF12 O 217 25 MWF9 O 113 25 TR2 O 113 25 TR9 O 113 25 MWF9 O 107 25 MWF10 O 107 25 MWF11 O 107 25 MWF12 O 107 25 MWF9 O 109 25 MWF10 O 109 25 MWF11 O 109 25 TR3:30 O 109 25 MWF9 O 217 25 MWF11 O 123 25 TR9 O 113 25 TR9 O 111 25 MWF9 O 111 25 MWF10 O 111 25 MWF11 O 123 25 MWF9 O 113 25 MWF10 O 217 25 MWF11 O 111 25 TIME ROOM STOPPOINT -------- -------- ---------- MWF12 O 111 25 TR9 O 113 25 MWF9 O 113 25 MWF10 O 113 25 TR2 O 217 25 MWF9 O 113 25 MWF10 O 113 25 MWF9 O 217 25 MWF12 O 113 25 MWF10 O 325 25 MWF11 O 113 25 MWF9 O 113 25 MWF10 O 113 25 MWF12 O 113 25 MWF9 O 217 25 MWF10 O 113 25 TR9 O 113 25 MWF9 O 325 25 MWF11 O 113 25 MWF10 O 113 25 MWF2 O 113 25 MWF9 O 325 25 MWF10 O 217 25 MWF11 O 123 25 TR2 O 113 25 MWF9 O 113 25 MWF10 O 113 25 MWF12 O 217 25 TR9 O 113 25 MWF9 O 113 25 MWF11 O 113 25 MWF10 O 113 25 MWF12 O 325 25 MWF11 O 113 25 MWF9 C 203 25 MWF11 O 113 25 MWF9 C 203 25 MWF12 O 113 25 MWF9 C 203 25 MWF11 O 113 25 MWF10 C 203 25 TR11 O 127 20 TR2 O 127 20 MW2 O 127 20 MWF12 O 107 25 T2 H 102 25 M6 H 102 25 MWF9 O 129 20 MW3:30 O 129 20 M6 O 129 20 164 rows selected. SQL> Select time, room, stoppoint from sections 2 Where room != 'O 129'; TIME ROOM STOPPOINT -------- -------- ---------- MWF 930 O 111 25 MWF 1130 O 107 25 MWF 1230 O 107 25 mw610 bs117 25 mw900 at123 99 mw120 bs134 35 tt200 bs134 35 mw610 at123 35 mw730 bs117 35 tt610 at123 35 mw610 fa229 35 mw610 fa221 30 mw120 fa229 35 tt1230 at205 35 tt740 at123 35 mw420 bs115 30 MWF8 O 200 20 MWF9 O 127 20 MWF10 O 200 20 MWF11 O 200 20 MWF12 O 200 20 MWF11 H 101 20 MWF12 H 101 20 MWF11R11 O 219 25 MWF12R2 O 217 25 MWF9 O 109 25 MWF10 O 215 25 R6 O 201 25 T6 O 200 25 MWF11 O 113 25 MWF11 O 109 25 MW2 O 200 25 MW3:30 O 201 25 MWF10 O 217 25 MWF9 O 325 25 MWF11 O 113 25 MWF12 O 123 25 MWF10 O 113 25 TR9 O 113 25 MWF9 O 325 25 MWF11 O 113 25 MWF10 O 217 25 TR2 O 113 25 MWF11 O 325 25 MWF12 O 123 25 MWF2 C 202 25 MWF9 C 203 25 MWF11 C 202 25 MWF10 C 203 25 TR9 C 206 25 TR3:30 C 202 25 MWF10 C 203 25 MWF11 C 206 25 MWF9 C 202 25 MWF12 C 203 25 MWF2 C 203 25 MWF10 C 203 25 TIME ROOM STOPPOINT -------- -------- ---------- MWF9 C 202 25 MWF11 C 202 25 MWF10 C 203 25 MWF12 C 206 25 MWF9 C 202 25 MWF10 C 203 25 TR9 C 206 25 MWF10 C 202 25 MWF9 C 203 25 MWF11 O 113 25 MWF10 O 325 25 TR2 O 325 25 MWF9 O 217 25 MWF11 O 113 25 TR2 O 113 25 MWF2 O 113 25 MWF9 O 113 25 MWF10 O 217 25 MWF11 O 325 25 TR3:30 O 113 25 MWF9 O 113 25 MWF10 O 217 25 MWF9 O 217 25 MWF12 O 123 25 MWF11 O 113 25 MWF2 O 325 25 MWF9 O 325 25 MWF10 O 113 25 TR9 O 217 25 MWF9 O 217 25 MWF11 O 123 25 MWF12 O 113 25 MWF10 O 113 25 MWF9 O 217 25 TR2 O 113 25 MWF12 O 217 25 MWF9 O 113 25 TR2 O 113 25 TR9 O 113 25 MWF9 O 107 25 MWF10 O 107 25 MWF11 O 107 25 MWF12 O 107 25 MWF9 O 109 25 MWF10 O 109 25 MWF11 O 109 25 TR3:30 O 109 25 MWF9 O 217 25 MWF11 O 123 25 TR9 O 113 25 TR9 O 111 25 MWF9 O 111 25 MWF10 O 111 25 MWF11 O 123 25 MWF9 O 113 25 MWF10 O 217 25 MWF11 O 111 25 TIME ROOM STOPPOINT -------- -------- ---------- MWF12 O 111 25 TR9 O 113 25 MWF9 O 113 25 MWF10 O 113 25 TR2 O 217 25 MWF9 O 113 25 MWF10 O 113 25 MWF9 O 217 25 MWF12 O 113 25 MWF10 O 325 25 MWF11 O 113 25 MWF9 O 113 25 MWF10 O 113 25 MWF12 O 113 25 MWF9 O 217 25 MWF10 O 113 25 TR9 O 113 25 MWF9 O 325 25 MWF11 O 113 25 MWF10 O 113 25 MWF2 O 113 25 MWF9 O 325 25 MWF10 O 217 25 MWF11 O 123 25 TR2 O 113 25 MWF9 O 113 25 MWF10 O 113 25 MWF12 O 217 25 TR9 O 113 25 MWF9 O 113 25 MWF11 O 113 25 MWF10 O 113 25 MWF12 O 325 25 MWF11 O 113 25 MWF9 C 203 25 MWF11 O 113 25 MWF9 C 203 25 MWF12 O 113 25 MWF9 C 203 25 MWF11 O 113 25 MWF10 C 203 25 TR11 O 127 20 TR2 O 127 20 MW2 O 127 20 MWF12 O 107 25 T2 H 102 25 M6 H 102 25 161 rows selected. SQL> Select * from students 2 Where gpa between 2.0 and 2.2; STUD FIRST M LAST YE MAJO NUMCREDITSEARNED GPA HOMETOWN BALANCEDUE ---- --------------- - --------------- -- ---- ---------------- ---------- -------------------- ---------- 1123 Shawn W Bradley Fr CSC 27 2.12 Palmyra 1500 SQL> Select * from students 2 Where gpa between 2.0 and 2.3; STUD FIRST M LAST YE MAJO NUMCREDITSEARNED GPA HOMETOWN BALANCEDUE ---- --------------- - --------------- -- ---- ---------------- ---------- -------------------- ---------- 1123 Shawn W Bradley Fr CSC 27 2.12 Palmyra 1500 SQL> Select * from students 2 Where gpa between 2.0 and 2.4; STUD FIRST M LAST YE MAJO NUMCREDITSEARNED GPA HOMETOWN BALANCEDUE ---- --------------- - --------------- -- ---- ---------------- ---------- -------------------- ---------- 1123 Shawn W Bradley Fr CSC 27 2.12 Palmyra 1500 5555 Penny A Hardaway Fr CSC 12 2.31 Cherry Hill 0 SQL> Select * from catalogcourses 2 Where title like '%Lang%'; DEPT COU TITLE DESCRIPTION ---- --- ------------------------------ ---------------------------------------------------------------------------------------------------- CREDITS ---------- CSC 366 Language Theory and Design Theory, finite automata, BNF, syntax, semantics, language paradigms 3 SQL> Select * from catalogcourses 2 Where title = '%Lang%'; no rows selected SQL> Select * from catalogcourses 2 Where title like '%lang%'; no rows selected SQL> Select * from enrollments where sectionid IN (66415, 66419); SECTI STUD SPECIALP GR ----- ---- -------- -- 66419 1093 D 66415 1111 134556 B 66419 1111 C 66419 1115 F 66415 1116 A 66419 1116 B 66419 1119 C 66415 1123 B 66415 5555 C 66419 1011 A 66419 2121 11 rows selected. SQL> Select rooms.*, capacity / numbstudentworkstations as ratio 2 From rooms; Select rooms.*, capacity / numbstudentworkstations as ratio * ERROR at line 1: ORA-01476: divisor is equal to zero SQL> Select rooms.*, capacity / numbstudentworkstations as ratio 2 From rooms 3 Where numbstudentworkstations > 0; ROOM CAPACITY F D D O NUMBSTUDENTWORKSTATIONS RATIO -------- ---------- - - - - ----------------------- ---------- bs117 20 1 1 1 1 16 1.25 C 203 20 1 1 1 1 20 1 C 206 20 1 1 1 1 20 1 H 101 20 1 1 1 1 20 1 O 127 20 1 1 1 1 20 1 O 129 20 1 1 1 1 20 1 O 200 25 1 1 1 1 25 1 O 201 25 1 1 1 1 25 1 8 rows selected. SQL> spool off