SQL> set pagesize 50 SQL> set linesize 120 SQL> describe students Name Null? Type ----------------------------------------------------------------- -------- -------------------------------------------- STUDENTID NOT NULL CHAR(4) FIRST NOT NULL VARCHAR2(15) MIDDLE CHAR(1) LAST NOT NULL VARCHAR2(15) YEAR NOT NULL CHAR(2) MAJOR CHAR(4) NUMCREDITSEARNED NUMBER(38) GPA NUMBER(4,3) HOMETOWN VARCHAR2(20) BALANCEDUE NUMBER(7,2) SQL> select * 2 from students; STUD FIRST M LAST YE MAJO NUMCREDITSEARNED GPA HOMETOWN BALANCEDUE ---- --------------- - --------------- -- ---- ---------------- ---------- -------------------- ---------- 1011 Ason J Kidd So MGMT 40 3.1 Oakland 0 1093 Chris T Webber So CSC 45 3.51 Haddonfield 2500 1111 Charles D Barkley Fr HIS 22 3 Pennsauken 0 1113 Kenny T Anderson So MGMT 54 2.85 Camden 1000 1115 Shaq O O'Neal Jr MKTG 94 3.82 Vorhees 0 1116 Allen X Iverson Jr BIO 81 2.87 Maple Shade 3500 1117 Grant P Hill Sr CSC 107 3.87 Pennsauken 0 1119 Marcus S Camby So CHEM 48 3.21 Pennsauken 50 1123 Shawn W Bradley Fr CSC 27 2.12 Palmyra 1500 1212 Kobe J Bryant So BIO 31 2.67 Lower Merion 125 1818 Kevin G Garnett Fr BIO 12 1.9 Chicago 0 2121 Keith V Van Horn Sr MGMT 91 2.98 Cherry Hill 100 2222 Larry R Hughes So BIO 13 3.1 Philadelphia 0 3131 Shane D Battier Fr CHEM 15 3.85 Vorhees 0 4141 Glenn B Robinson Jr HIS 70 2.5 Philadelphia 120 5151 Baron U Davis So BIO 32 2.99 Westwood 0 5555 Penny A Hardaway Fr CSC 12 2.31 Cherry Hill 0 6161 Michael S Jordan Sr MKTG 110 3.65 Wilmington 0 7070 Tim D Duncan Sr HIS 99 3.87 San Antonio 10 7171 Paul P Pierce So CHEM 35 3.1 Boston 100 20 rows selected. SQL> SELECT * 2 FROM STUDENTS; STUD FIRST M LAST YE MAJO NUMCREDITSEARNED GPA HOMETOWN BALANCEDUE ---- --------------- - --------------- -- ---- ---------------- ---------- -------------------- ---------- 1011 Ason J Kidd So MGMT 40 3.1 Oakland 0 1093 Chris T Webber So CSC 45 3.51 Haddonfield 2500 1111 Charles D Barkley Fr HIS 22 3 Pennsauken 0 1113 Kenny T Anderson So MGMT 54 2.85 Camden 1000 1115 Shaq O O'Neal Jr MKTG 94 3.82 Vorhees 0 1116 Allen X Iverson Jr BIO 81 2.87 Maple Shade 3500 1117 Grant P Hill Sr CSC 107 3.87 Pennsauken 0 1119 Marcus S Camby So CHEM 48 3.21 Pennsauken 50 1123 Shawn W Bradley Fr CSC 27 2.12 Palmyra 1500 1212 Kobe J Bryant So BIO 31 2.67 Lower Merion 125 1818 Kevin G Garnett Fr BIO 12 1.9 Chicago 0 2121 Keith V Van Horn Sr MGMT 91 2.98 Cherry Hill 100 2222 Larry R Hughes So BIO 13 3.1 Philadelphia 0 3131 Shane D Battier Fr CHEM 15 3.85 Vorhees 0 4141 Glenn B Robinson Jr HIS 70 2.5 Philadelphia 120 5151 Baron U Davis So BIO 32 2.99 Westwood 0 5555 Penny A Hardaway Fr CSC 12 2.31 Cherry Hill 0 6161 Michael S Jordan Sr MKTG 110 3.65 Wilmington 0 7070 Tim D Duncan Sr HIS 99 3.87 San Antonio 10 7171 Paul P Pierce So CHEM 35 3.1 Boston 100 20 rows selected. SQL> select studentid, first, last 2 from students 3 ; STUD FIRST LAST ---- --------------- --------------- 1011 Ason Kidd 1093 Chris Webber 1111 Charles Barkley 1113 Kenny Anderson 1115 Shaq O'Neal 1116 Allen Iverson 1117 Grant Hill 1119 Marcus Camby 1123 Shawn Bradley 1212 Kobe Bryant 1818 Kevin Garnett 2121 Keith Van Horn 2222 Larry Hughes 3131 Shane Battier 4141 Glenn Robinson 5151 Baron Davis 5555 Penny Hardaway 6161 Michael Jordan 7070 Tim Duncan 7171 Paul Pierce 20 rows selected. SQL> select major from students; MAJO ---- MGMT CSC HIS MGMT MKTG BIO CSC CHEM CSC BIO BIO MGMT BIO CHEM HIS BIO CSC MKTG HIS CHEM 20 rows selected. SQL> select distinct major from students; MAJO ---- HIS CHEM MGMT BIO CSC MKTG 6 rows selected. SQL> select * 2 from students 3 where year = 'Fr'; STUD FIRST M LAST YE MAJO NUMCREDITSEARNED GPA HOMETOWN BALANCEDUE ---- --------------- - --------------- -- ---- ---------------- ---------- -------------------- ---------- 1111 Charles D Barkley Fr HIS 22 3 Pennsauken 0 1123 Shawn W Bradley Fr CSC 27 2.12 Palmyra 1500 1818 Kevin G Garnett Fr BIO 12 1.9 Chicago 0 3131 Shane D Battier Fr CHEM 15 3.85 Vorhees 0 5555 Penny A Hardaway Fr CSC 12 2.31 Cherry Hill 0 SQL> select * 2 from students 3 where year = 'fr'; no rows selected SQL> select * 2 from students 3 where year = 'Fr' 4 and gpa < 3.0 5 ; STUD FIRST M LAST YE MAJO NUMCREDITSEARNED GPA HOMETOWN BALANCEDUE ---- --------------- - --------------- -- ---- ---------------- ---------- -------------------- ---------- 1123 Shawn W Bradley Fr CSC 27 2.12 Palmyra 1500 1818 Kevin G Garnett Fr BIO 12 1.9 Chicago 0 5555 Penny A Hardaway Fr CSC 12 2.31 Cherry Hill 0 SQL> select studentid, last, first, year, gpa 2 from students 3 where year = 'Fr' and gpa < 3.0; STUD LAST FIRST YE GPA ---- --------------- --------------- -- ---------- 1123 Bradley Shawn Fr 2.12 1818 Garnett Kevin Fr 1.9 5555 Hardaway Penny Fr 2.31 SQL> select * from students 2 order by gpa; STUD FIRST M LAST YE MAJO NUMCREDITSEARNED GPA HOMETOWN BALANCEDUE ---- --------------- - --------------- -- ---- ---------------- ---------- -------------------- ---------- 1818 Kevin G Garnett Fr BIO 12 1.9 Chicago 0 1123 Shawn W Bradley Fr CSC 27 2.12 Palmyra 1500 5555 Penny A Hardaway Fr CSC 12 2.31 Cherry Hill 0 4141 Glenn B Robinson Jr HIS 70 2.5 Philadelphia 120 1212 Kobe J Bryant So BIO 31 2.67 Lower Merion 125 1113 Kenny T Anderson So MGMT 54 2.85 Camden 1000 1116 Allen X Iverson Jr BIO 81 2.87 Maple Shade 3500 2121 Keith V Van Horn Sr MGMT 91 2.98 Cherry Hill 100 5151 Baron U Davis So BIO 32 2.99 Westwood 0 1111 Charles D Barkley Fr HIS 22 3 Pennsauken 0 7171 Paul P Pierce So CHEM 35 3.1 Boston 100 1011 Ason J Kidd So MGMT 40 3.1 Oakland 0 2222 Larry R Hughes So BIO 13 3.1 Philadelphia 0 1119 Marcus S Camby So CHEM 48 3.21 Pennsauken 50 1093 Chris T Webber So CSC 45 3.51 Haddonfield 2500 6161 Michael S Jordan Sr MKTG 110 3.65 Wilmington 0 1115 Shaq O O'Neal Jr MKTG 94 3.82 Vorhees 0 3131 Shane D Battier Fr CHEM 15 3.85 Vorhees 0 1117 Grant P Hill Sr CSC 107 3.87 Pennsauken 0 7070 Tim D Duncan Sr HIS 99 3.87 San Antonio 10 20 rows selected. SQL> select * from students 2 order by gpa desc; STUD FIRST M LAST YE MAJO NUMCREDITSEARNED GPA HOMETOWN BALANCEDUE ---- --------------- - --------------- -- ---- ---------------- ---------- -------------------- ---------- 7070 Tim D Duncan Sr HIS 99 3.87 San Antonio 10 1117 Grant P Hill Sr CSC 107 3.87 Pennsauken 0 3131 Shane D Battier Fr CHEM 15 3.85 Vorhees 0 1115 Shaq O O'Neal Jr MKTG 94 3.82 Vorhees 0 6161 Michael S Jordan Sr MKTG 110 3.65 Wilmington 0 1093 Chris T Webber So CSC 45 3.51 Haddonfield 2500 1119 Marcus S Camby So CHEM 48 3.21 Pennsauken 50 2222 Larry R Hughes So BIO 13 3.1 Philadelphia 0 1011 Ason J Kidd So MGMT 40 3.1 Oakland 0 7171 Paul P Pierce So CHEM 35 3.1 Boston 100 1111 Charles D Barkley Fr HIS 22 3 Pennsauken 0 5151 Baron U Davis So BIO 32 2.99 Westwood 0 2121 Keith V Van Horn Sr MGMT 91 2.98 Cherry Hill 100 1116 Allen X Iverson Jr BIO 81 2.87 Maple Shade 3500 1113 Kenny T Anderson So MGMT 54 2.85 Camden 1000 1212 Kobe J Bryant So BIO 31 2.67 Lower Merion 125 4141 Glenn B Robinson Jr HIS 70 2.5 Philadelphia 120 5555 Penny A Hardaway Fr CSC 12 2.31 Cherry Hill 0 1123 Shawn W Bradley Fr CSC 27 2.12 Palmyra 1500 1818 Kevin G Garnett Fr BIO 12 1.9 Chicago 0 20 rows selected. SQL> spool off SQL> select * in enrollments; select * in enrollments * ERROR at line 1: ORA-00923: FROM keyword not found where expected SQL> select * from enrollments; SECTI STUD SPECIALP GR ----- ---- -------- -- 80104 1011 80414 1011 80493 1011 80520 1011 62341 1093 A 66416 1093 B 66419 1093 D 70234 1093 A 80311 1093 80322 1093 80443 1093 80474 1093 62341 1111 F 66415 1111 134556 B 66419 1111 C 80104 1111 80435 1111 80447 1111 80503 1111 62272 1113 A 62341 1113 C 66417 1113 A 80103 1113 80414 1113 80443 1113 80449 1113 80465 1113 66416 1115 103455 A 66417 1115 A 66419 1115 F 80103 1115 80414 1115 80433 1115 80435 1115 80449 1115 80465 1115 80519 1115 62341 1116 B 66415 1116 A 66419 1116 B 80405 1116 80408 1116 80453 1116 80465 1116 80501 1116 80516 1116 62272 1117 C SECTI STUD SPECIALP GR ----- ---- -------- -- 67488 1117 A 69705 1117 A 80361 1117 80371 1117 80472 1117 80515 1117 80519 1117 82111 1117 11112 1119 B 66417 1119 B 66419 1119 C 80102 1119 80403 1119 80408 1119 80452 1119 80470 1119 80494 1119 62272 1123 D 62341 1123 A 66415 1123 B 66422 1123 B 70232 1123 B 80301 1123 80321 1123 80447 1123 80470 1123 80491 1123 80511 1123 80201 1212 80405 1212 80408 1212 80452 1212 80471 1212 80492 1212 80202 1818 80403 1818 80406 1818 80451 1818 80469 1818 80496 1818 80301 2121 80419 2121 80424 2121 80494 2121 81201 2121 80201 2222 80405 2222 SECTI STUD SPECIALP GR ----- ---- -------- -- 80406 2222 80453 2222 80511 2222 80202 3131 80403 3131 80410 3131 80436 3131 80463 3131 80438 4141 80492 4141 80505 4141 80506 4141 80514 4141 80405 5151 80408 5151 80449 5151 80466 5151 80496 5151 11111 5555 A 62272 5555 B 62341 5555 A 66415 5555 C 70234 5555 B 70238 5555 D 80311 5555 80436 5555 80448 5555 80474 5555 80494 5555 80301 6161 80414 6161 80431 6161 80433 6161 80496 6161 80103 7070 80461 7070 80505 7070 80506 7070 80514 7070 80202 7171 80405 7171 80412 7171 80457 7171 80475 7171 138 rows selected. SQL> select students.studentid, last, 2 first, sectionid 3 from students, 4 enrollments 5 where enrollments.studentid 6 = students.studentid; STUD LAST FIRST SECTI ---- --------------- --------------- ----- 5555 Hardaway Penny 11111 1119 Camby Marcus 11112 1113 Anderson Kenny 62272 1117 Hill Grant 62272 1123 Bradley Shawn 62272 5555 Hardaway Penny 62272 1093 Webber Chris 62341 1111 Barkley Charles 62341 1113 Anderson Kenny 62341 1116 Iverson Allen 62341 1123 Bradley Shawn 62341 5555 Hardaway Penny 62341 1111 Barkley Charles 66415 1116 Iverson Allen 66415 1123 Bradley Shawn 66415 5555 Hardaway Penny 66415 1093 Webber Chris 66416 1115 O'Neal Shaq 66416 1113 Anderson Kenny 66417 1115 O'Neal Shaq 66417 1119 Camby Marcus 66417 1093 Webber Chris 66419 1111 Barkley Charles 66419 1115 O'Neal Shaq 66419 1116 Iverson Allen 66419 1119 Camby Marcus 66419 1123 Bradley Shawn 66422 1117 Hill Grant 67488 1117 Hill Grant 69705 1123 Bradley Shawn 70232 1093 Webber Chris 70234 5555 Hardaway Penny 70234 5555 Hardaway Penny 70238 1119 Camby Marcus 80102 1113 Anderson Kenny 80103 1115 O'Neal Shaq 80103 7070 Duncan Tim 80103 1011 Kidd Ason 80104 1111 Barkley Charles 80104 1212 Bryant Kobe 80201 2222 Hughes Larry 80201 1818 Garnett Kevin 80202 3131 Battier Shane 80202 7171 Pierce Paul 80202 1123 Bradley Shawn 80301 2121 Van Horn Keith 80301 6161 Jordan Michael 80301 STUD LAST FIRST SECTI ---- --------------- --------------- ----- 1093 Webber Chris 80311 5555 Hardaway Penny 80311 1123 Bradley Shawn 80321 1093 Webber Chris 80322 1117 Hill Grant 80361 1117 Hill Grant 80371 1119 Camby Marcus 80403 1818 Garnett Kevin 80403 3131 Battier Shane 80403 1116 Iverson Allen 80405 1212 Bryant Kobe 80405 2222 Hughes Larry 80405 5151 Davis Baron 80405 7171 Pierce Paul 80405 1818 Garnett Kevin 80406 2222 Hughes Larry 80406 1116 Iverson Allen 80408 1119 Camby Marcus 80408 1212 Bryant Kobe 80408 5151 Davis Baron 80408 3131 Battier Shane 80410 7171 Pierce Paul 80412 1011 Kidd Ason 80414 1113 Anderson Kenny 80414 1115 O'Neal Shaq 80414 6161 Jordan Michael 80414 2121 Van Horn Keith 80419 2121 Van Horn Keith 80424 6161 Jordan Michael 80431 1115 O'Neal Shaq 80433 6161 Jordan Michael 80433 1111 Barkley Charles 80435 1115 O'Neal Shaq 80435 3131 Battier Shane 80436 5555 Hardaway Penny 80436 4141 Robinson Glenn 80438 1093 Webber Chris 80443 1113 Anderson Kenny 80443 1111 Barkley Charles 80447 1123 Bradley Shawn 80447 5555 Hardaway Penny 80448 1113 Anderson Kenny 80449 1115 O'Neal Shaq 80449 5151 Davis Baron 80449 1818 Garnett Kevin 80451 1119 Camby Marcus 80452 1212 Bryant Kobe 80452 STUD LAST FIRST SECTI ---- --------------- --------------- ----- 1116 Iverson Allen 80453 2222 Hughes Larry 80453 7171 Pierce Paul 80457 7070 Duncan Tim 80461 3131 Battier Shane 80463 1113 Anderson Kenny 80465 1115 O'Neal Shaq 80465 1116 Iverson Allen 80465 5151 Davis Baron 80466 1818 Garnett Kevin 80469 1119 Camby Marcus 80470 1123 Bradley Shawn 80470 1212 Bryant Kobe 80471 1117 Hill Grant 80472 1093 Webber Chris 80474 5555 Hardaway Penny 80474 7171 Pierce Paul 80475 1123 Bradley Shawn 80491 1212 Bryant Kobe 80492 4141 Robinson Glenn 80492 1011 Kidd Ason 80493 1119 Camby Marcus 80494 2121 Van Horn Keith 80494 5555 Hardaway Penny 80494 1818 Garnett Kevin 80496 5151 Davis Baron 80496 6161 Jordan Michael 80496 1116 Iverson Allen 80501 1111 Barkley Charles 80503 4141 Robinson Glenn 80505 7070 Duncan Tim 80505 4141 Robinson Glenn 80506 7070 Duncan Tim 80506 1123 Bradley Shawn 80511 2222 Hughes Larry 80511 4141 Robinson Glenn 80514 7070 Duncan Tim 80514 1117 Hill Grant 80515 1116 Iverson Allen 80516 1115 O'Neal Shaq 80519 1117 Hill Grant 80519 1011 Kidd Ason 80520 2121 Van Horn Keith 81201 1117 Hill Grant 82111 138 rows selected. SQL> select students.studentid, 2 enrollments.studentid, 3 last, first, sectionid 4 from students, 5 enrollments 6 where enrollments.studentid 7 = students.studentid; STUD STUD LAST FIRST SECTI ---- ---- --------------- --------------- ----- 5555 5555 Hardaway Penny 11111 1119 1119 Camby Marcus 11112 1113 1113 Anderson Kenny 62272 1117 1117 Hill Grant 62272 1123 1123 Bradley Shawn 62272 5555 5555 Hardaway Penny 62272 1093 1093 Webber Chris 62341 1111 1111 Barkley Charles 62341 1113 1113 Anderson Kenny 62341 1116 1116 Iverson Allen 62341 1123 1123 Bradley Shawn 62341 5555 5555 Hardaway Penny 62341 1111 1111 Barkley Charles 66415 1116 1116 Iverson Allen 66415 1123 1123 Bradley Shawn 66415 5555 5555 Hardaway Penny 66415 1093 1093 Webber Chris 66416 1115 1115 O'Neal Shaq 66416 1113 1113 Anderson Kenny 66417 1115 1115 O'Neal Shaq 66417 1119 1119 Camby Marcus 66417 1093 1093 Webber Chris 66419 1111 1111 Barkley Charles 66419 1115 1115 O'Neal Shaq 66419 1116 1116 Iverson Allen 66419 1119 1119 Camby Marcus 66419 1123 1123 Bradley Shawn 66422 1117 1117 Hill Grant 67488 1117 1117 Hill Grant 69705 1123 1123 Bradley Shawn 70232 1093 1093 Webber Chris 70234 5555 5555 Hardaway Penny 70234 5555 5555 Hardaway Penny 70238 1119 1119 Camby Marcus 80102 1113 1113 Anderson Kenny 80103 1115 1115 O'Neal Shaq 80103 7070 7070 Duncan Tim 80103 1011 1011 Kidd Ason 80104 1111 1111 Barkley Charles 80104 1212 1212 Bryant Kobe 80201 2222 2222 Hughes Larry 80201 1818 1818 Garnett Kevin 80202 3131 3131 Battier Shane 80202 7171 7171 Pierce Paul 80202 1123 1123 Bradley Shawn 80301 2121 2121 Van Horn Keith 80301 6161 6161 Jordan Michael 80301 STUD STUD LAST FIRST SECTI ---- ---- --------------- --------------- ----- 1093 1093 Webber Chris 80311 5555 5555 Hardaway Penny 80311 1123 1123 Bradley Shawn 80321 1093 1093 Webber Chris 80322 1117 1117 Hill Grant 80361 1117 1117 Hill Grant 80371 1119 1119 Camby Marcus 80403 1818 1818 Garnett Kevin 80403 3131 3131 Battier Shane 80403 1116 1116 Iverson Allen 80405 1212 1212 Bryant Kobe 80405 2222 2222 Hughes Larry 80405 5151 5151 Davis Baron 80405 7171 7171 Pierce Paul 80405 1818 1818 Garnett Kevin 80406 2222 2222 Hughes Larry 80406 1116 1116 Iverson Allen 80408 1119 1119 Camby Marcus 80408 1212 1212 Bryant Kobe 80408 5151 5151 Davis Baron 80408 3131 3131 Battier Shane 80410 7171 7171 Pierce Paul 80412 1011 1011 Kidd Ason 80414 1113 1113 Anderson Kenny 80414 1115 1115 O'Neal Shaq 80414 6161 6161 Jordan Michael 80414 2121 2121 Van Horn Keith 80419 2121 2121 Van Horn Keith 80424 6161 6161 Jordan Michael 80431 1115 1115 O'Neal Shaq 80433 6161 6161 Jordan Michael 80433 1111 1111 Barkley Charles 80435 1115 1115 O'Neal Shaq 80435 3131 3131 Battier Shane 80436 5555 5555 Hardaway Penny 80436 4141 4141 Robinson Glenn 80438 1093 1093 Webber Chris 80443 1113 1113 Anderson Kenny 80443 1111 1111 Barkley Charles 80447 1123 1123 Bradley Shawn 80447 5555 5555 Hardaway Penny 80448 1113 1113 Anderson Kenny 80449 1115 1115 O'Neal Shaq 80449 5151 5151 Davis Baron 80449 1818 1818 Garnett Kevin 80451 1119 1119 Camby Marcus 80452 1212 1212 Bryant Kobe 80452 STUD STUD LAST FIRST SECTI ---- ---- --------------- --------------- ----- 1116 1116 Iverson Allen 80453 2222 2222 Hughes Larry 80453 7171 7171 Pierce Paul 80457 7070 7070 Duncan Tim 80461 3131 3131 Battier Shane 80463 1113 1113 Anderson Kenny 80465 1115 1115 O'Neal Shaq 80465 1116 1116 Iverson Allen 80465 5151 5151 Davis Baron 80466 1818 1818 Garnett Kevin 80469 1119 1119 Camby Marcus 80470 1123 1123 Bradley Shawn 80470 1212 1212 Bryant Kobe 80471 1117 1117 Hill Grant 80472 1093 1093 Webber Chris 80474 5555 5555 Hardaway Penny 80474 7171 7171 Pierce Paul 80475 1123 1123 Bradley Shawn 80491 1212 1212 Bryant Kobe 80492 4141 4141 Robinson Glenn 80492 1011 1011 Kidd Ason 80493 1119 1119 Camby Marcus 80494 2121 2121 Van Horn Keith 80494 5555 5555 Hardaway Penny 80494 1818 1818 Garnett Kevin 80496 5151 5151 Davis Baron 80496 6161 6161 Jordan Michael 80496 1116 1116 Iverson Allen 80501 1111 1111 Barkley Charles 80503 4141 4141 Robinson Glenn 80505 7070 7070 Duncan Tim 80505 4141 4141 Robinson Glenn 80506 7070 7070 Duncan Tim 80506 1123 1123 Bradley Shawn 80511 2222 2222 Hughes Larry 80511 4141 4141 Robinson Glenn 80514 7070 7070 Duncan Tim 80514 1117 1117 Hill Grant 80515 1116 1116 Iverson Allen 80516 1115 1115 O'Neal Shaq 80519 1117 1117 Hill Grant 80519 1011 1011 Kidd Ason 80520 2121 2121 Van Horn Keith 81201 1117 1117 Hill Grant 82111 138 rows selected. SQL> select students.studentid, 2 last, first, sections.sectionid, dept, course 3 from students, enrollments, sections 4 where enrollments.studentid 5 = students.studentid 6 and 7 enrollments.sectionid 8 = sections.sectionid; STUD LAST FIRST SECTI DEPT COU ---- --------------- --------------- ----- ---- --- 5555 Hardaway Penny 11111 CSC 157 1119 Camby Marcus 11112 CSC 157 1113 Anderson Kenny 62272 CSC 151 1117 Hill Grant 62272 CSC 151 1123 Bradley Shawn 62272 CSC 151 5555 Hardaway Penny 62272 CSC 151 1093 Webber Chris 62341 CHEM 111 1111 Barkley Charles 62341 CHEM 111 1113 Anderson Kenny 62341 CHEM 111 1116 Iverson Allen 62341 CHEM 111 1123 Bradley Shawn 62341 CHEM 111 5555 Hardaway Penny 62341 CHEM 111 1111 Barkley Charles 66415 CSC 151 1116 Iverson Allen 66415 CSC 151 1123 Bradley Shawn 66415 CSC 151 5555 Hardaway Penny 66415 CSC 151 1093 Webber Chris 66416 CSC 151 1115 O'Neal Shaq 66416 CSC 151 1113 Anderson Kenny 66417 CSC 151 1115 O'Neal Shaq 66417 CSC 151 1119 Camby Marcus 66417 CSC 151 1093 Webber Chris 66419 CSC 152 1111 Barkley Charles 66419 CSC 152 1115 O'Neal Shaq 66419 CSC 152 1116 Iverson Allen 66419 CSC 152 1119 Camby Marcus 66419 CSC 152 1123 Bradley Shawn 66422 CSC 265 1117 Hill Grant 67488 CSIT 447 1117 Hill Grant 69705 CSIT 365 1123 Bradley Shawn 70232 CSIT 136 1093 Webber Chris 70234 CSIT 136 5555 Hardaway Penny 70234 CSIT 136 5555 Hardaway Penny 70238 CSIT 461 1119 Camby Marcus 80102 CSC 151 1113 Anderson Kenny 80103 CSC 151 1115 O'Neal Shaq 80103 CSC 151 7070 Duncan Tim 80103 CSC 151 1011 Kidd Ason 80104 CSC 151 1111 Barkley Charles 80104 CSC 151 1212 Bryant Kobe 80201 CSC 152 2222 Hughes Larry 80201 CSC 152 1818 Garnett Kevin 80202 CSC 152 3131 Battier Shane 80202 CSC 152 7171 Pierce Paul 80202 CSC 152 1123 Bradley Shawn 80301 CSC 157 2121 Van Horn Keith 80301 CSC 157 6161 Jordan Michael 80301 CSC 157 STUD LAST FIRST SECTI DEPT COU ---- --------------- --------------- ----- ---- --- 1093 Webber Chris 80311 CSC 162 5555 Hardaway Penny 80311 CSC 162 1123 Bradley Shawn 80321 CSC 264 1093 Webber Chris 80322 CSC 264 1117 Hill Grant 80361 CSC 372 1117 Hill Grant 80371 CSC 480 1119 Camby Marcus 80403 BIO 180 1818 Garnett Kevin 80403 BIO 180 3131 Battier Shane 80403 BIO 180 1116 Iverson Allen 80405 BIO 210 1212 Bryant Kobe 80405 BIO 210 2222 Hughes Larry 80405 BIO 210 5151 Davis Baron 80405 BIO 210 7171 Pierce Paul 80405 BIO 210 1818 Garnett Kevin 80406 CHEM 111 2222 Hughes Larry 80406 CHEM 111 1116 Iverson Allen 80408 CHEM 201 1119 Camby Marcus 80408 CHEM 201 1212 Bryant Kobe 80408 CHEM 201 5151 Davis Baron 80408 CHEM 201 3131 Battier Shane 80410 CHEM 111 7171 Pierce Paul 80412 CHEM 201 1011 Kidd Ason 80414 MGMT 302 1113 Anderson Kenny 80414 MGMT 302 1115 O'Neal Shaq 80414 MGMT 302 6161 Jordan Michael 80414 MGMT 302 2121 Van Horn Keith 80419 MGMT 354 2121 Van Horn Keith 80424 MGMT 353 6161 Jordan Michael 80431 MKTG 305 1115 O'Neal Shaq 80433 MKTG 301 6161 Jordan Michael 80433 MKTG 301 1111 Barkley Charles 80435 ECN 150 1115 O'Neal Shaq 80435 ECN 150 3131 Battier Shane 80436 ECN 150 5555 Hardaway Penny 80436 ECN 150 4141 Robinson Glenn 80438 ECN 213 1093 Webber Chris 80443 ECN 155 1113 Anderson Kenny 80443 ECN 155 1111 Barkley Charles 80447 ENG 107 1123 Bradley Shawn 80447 ENG 107 5555 Hardaway Penny 80448 ENG 108 1113 Anderson Kenny 80449 ENG 150 1115 O'Neal Shaq 80449 ENG 150 5151 Davis Baron 80449 ENG 150 1818 Garnett Kevin 80451 ENG 107 1119 Camby Marcus 80452 ENG 150 1212 Bryant Kobe 80452 ENG 150 STUD LAST FIRST SECTI DEPT COU ---- --------------- --------------- ----- ---- --- 1116 Iverson Allen 80453 ENG 150 2222 Hughes Larry 80453 ENG 150 7171 Pierce Paul 80457 ENG 150 7070 Duncan Tim 80461 ENG 203 3131 Battier Shane 80463 ENG 107 1113 Anderson Kenny 80465 MTH 117 1115 O'Neal Shaq 80465 MTH 117 1116 Iverson Allen 80465 MTH 117 5151 Davis Baron 80466 MTH 120 1818 Garnett Kevin 80469 MTH 113 1119 Camby Marcus 80470 MTH 120 1123 Bradley Shawn 80470 MTH 120 1212 Bryant Kobe 80471 MTH 120 1117 Hill Grant 80472 MTH 240 1093 Webber Chris 80474 MTH 140 5555 Hardaway Penny 80474 MTH 140 7171 Pierce Paul 80475 MTH 221 1123 Bradley Shawn 80491 PSY 155 1212 Bryant Kobe 80492 PSY 155 4141 Robinson Glenn 80492 PSY 155 1011 Kidd Ason 80493 REL 150 1119 Camby Marcus 80494 REL 153 2121 Van Horn Keith 80494 REL 153 5555 Hardaway Penny 80494 REL 153 1818 Garnett Kevin 80496 REL 153 5151 Davis Baron 80496 REL 153 6161 Jordan Michael 80496 REL 153 1116 Iverson Allen 80501 HIS 305 1111 Barkley Charles 80503 HIS 151 4141 Robinson Glenn 80505 HIS 329 7070 Duncan Tim 80505 HIS 329 4141 Robinson Glenn 80506 HIS 333 7070 Duncan Tim 80506 HIS 333 1123 Bradley Shawn 80511 HIS 151 2222 Hughes Larry 80511 HIS 151 4141 Robinson Glenn 80514 HIS 324 7070 Duncan Tim 80514 HIS 324 1117 Hill Grant 80515 POL 151 1116 Iverson Allen 80516 POL 151 1115 O'Neal Shaq 80519 BUS 200 1117 Hill Grant 80519 BUS 200 1011 Kidd Ason 80520 BUS 150 2121 Van Horn Keith 81201 CSIT 362 1117 Hill Grant 82111 CSD 340 138 rows selected. SQL> select students.studentid, last, first, 2 year, major 3 from students, enrollments 4 where enrollments.studentid 5 = students.studentid 6 and sectionid = '66419'; STUD LAST FIRST YE MAJO ---- --------------- --------------- -- ---- 1093 Webber Chris So CSC 1111 Barkley Charles Fr HIS 1115 O'Neal Shaq Jr MKTG 1116 Iverson Allen Jr BIO 1119 Camby Marcus So CHEM SQL> SQL> select room from sections; ROOM -------- O 111 O 107 O 107 bs117 at123 bs134 bs134 at123 bs117 at123 fa229 fa221 fa229 at205 at123 bs115 O 200 O 127 O 200 O 200 O 200 H 101 H 101 O 219 O 217 O 109 O 215 O 201 O 200 O 113 O 109 O 200 O 201 O 217 O 325 O 113 O 123 O 113 O 113 O 325 O 113 O 217 O 113 O 325 O 123 C 202 C 203 ROOM -------- C 202 C 203 C 206 C 202 C 203 C 206 C 202 C 203 C 203 C 203 C 202 C 202 C 203 C 206 C 202 C 203 C 206 C 202 C 203 O 113 O 325 O 325 O 217 O 113 O 113 O 113 O 113 O 217 O 325 O 113 O 113 O 217 O 217 O 123 O 113 O 325 O 325 O 113 O 217 O 217 O 123 O 113 O 113 O 217 O 113 O 217 O 113 ROOM -------- O 113 O 113 O 107 O 107 O 107 O 107 O 109 O 109 O 109 O 109 O 217 O 123 O 113 O 111 O 111 O 111 O 123 O 113 O 217 O 111 O 111 O 113 O 113 O 113 O 217 O 113 O 113 O 217 O 113 O 325 O 113 O 113 O 113 O 113 O 217 O 113 O 113 O 325 O 113 O 113 O 113 O 325 O 217 O 123 O 113 O 113 O 113 ROOM -------- O 217 O 113 O 113 O 113 O 113 O 325 O 113 C 203 O 113 C 203 O 113 C 203 O 113 C 203 O 127 O 127 O 127 O 107 H 102 H 102 O 129 O 129 O 129 164 rows selected. SQL> select * from sections 2 where room = 'O 129'; SECTI DEPT COU SE SE YEAR TIME ROOM PROFESSOR STOPPOINT JUNK ----- ---- --- -- -- ---------- -------- -------- --------------- ---------- ---------- 82101 CSD 210 01 F 2002 MWF9 O 129 Leister 20 82102 CSD 210 02 F 2002 MW3:30 O 129 Leister 20 82111 CSD 340 01 F 2002 M6 O 129 Camomile 20 SQL> select * from sections 2 where room <> 'O 129'; SECTI DEPT COU SE SE YEAR TIME ROOM PROFESSOR STOPPOINT JUNK ----- ---- --- -- -- ---------- -------- -------- --------------- ---------- ---------- 11111 CSC 157 01 F 1999 MWF 930 O 111 Redmond 25 11112 CSC 157 02 F 1999 MWF 1130 O 107 Redmond 25 11121 CSC 162 01 F 1999 MWF 1230 O 107 Turk 25 62272 CSC 151 01 F 1996 mw610 bs117 Grant 25 62341 CHEM 111 01 S 1997 mw900 at123 Burke 99 66415 CSC 151 01 S 1997 mw120 bs134 Stevens 35 66416 CSC 151 02 S 1997 tt200 bs134 Stevens 35 66417 CSC 151 40 S 1997 mw610 at123 Mead 35 66418 CSC 151 41 S 1997 mw730 bs117 Grant 35 66419 CSC 152 40 S 1997 tt610 at123 Billa 35 66422 CSC 265 40 S 1997 mw610 fa229 Kolasa 35 67488 CSIT 447 40 S 1997 mw610 fa221 Ma 30 69705 CSIT 365 01 S 1997 mw120 fa229 Redmond 35 70232 CSIT 136 01 S 1997 tt1230 at205 Venkatesan 35 70234 CSIT 136 40 S 1997 tt740 at123 Kolasa 35 70238 CSIT 461 40 S 1997 mw420 bs115 Redmond 30 80101 CSC 151 01 F 2002 MWF8 O 200 Wiley 20 80102 CSC 151 02 F 2002 MWF9 O 127 Wiley 20 80103 CSC 151 03 F 2002 MWF10 O 200 Young 20 80104 CSC 151 04 F 2002 MWF11 O 200 Young 20 80105 CSC 151 05 F 2002 MWF12 O 200 Young 20 80201 CSC 152 01 F 2002 MWF11 H 101 DiDio 20 80202 CSC 152 01 F 2002 MWF12 H 101 DiDio 20 80301 CSC 157 01 F 2002 MWF11R11 O 219 Elliott 25 80311 CSC 162 01 F 2002 MWF12R2 O 217 Turk 25 80321 CSC 264 01 F 2002 MWF9 O 109 Blum 25 80322 CSC 264 02 F 2002 MWF10 O 215 Redmond 25 80323 CSC 264 03 F 2002 R6 O 201 Reichardt 25 80331 CSC 352 01 F 2002 T6 O 200 Turk 25 80341 CSC 354 01 F 2002 MWF11 O 113 Turk 25 80351 CSC 362 01 F 2002 MWF11 O 109 Kirsch 25 80361 CSC 372 01 F 2002 MW2 O 200 Wiley 25 80371 CSC 480 01 F 2002 MW3:30 O 201 Kirsch 25 80402 BIO 157 01 F 2002 MWF10 O 217 Ballough 25 80403 BIO 180 01 F 2002 MWF9 O 325 Ballough 25 80404 BIO 161 01 F 2002 MWF11 O 113 Ballough 25 80405 BIO 210 01 F 2002 MWF12 O 123 Ballough 25 80406 CHEM 111 01 F 2002 MWF10 O 113 Jones N 25 80407 CHEM 150 01 F 2002 TR9 O 113 Jones N 25 80408 CHEM 201 01 F 2002 MWF9 O 325 Jones N 25 80409 CHEM 301 01 F 2002 MWF11 O 113 Jones N 25 80410 CHEM 111 02 F 2002 MWF10 O 217 Shalhoub 25 80411 CHEM 150 02 F 2002 TR2 O 113 Shalhoub 25 80412 CHEM 201 02 F 2002 MWF11 O 325 Shalhoub 25 80413 CHEM 301 02 F 2002 MWF12 O 123 Shalhoub 25 80414 MGMT 302 01 F 2002 MWF2 C 202 Bruce 25 80415 MGMT 353 01 F 2002 MWF9 C 203 Bruce 25 SECTI DEPT COU SE SE YEAR TIME ROOM PROFESSOR STOPPOINT JUNK ----- ---- --- -- -- ---------- -------- -------- --------------- ---------- ---------- 80416 MGMT 353 02 F 2002 MWF11 C 202 Bruce 25 80417 MGMT 302 02 F 2002 MWF10 C 203 Joglekar 25 80418 MGMT 354 01 F 2002 TR9 C 206 Joglekar 25 80419 MGMT 354 02 F 2002 TR3:30 C 202 Joglekar 25 80420 MGMT 302 03 F 2002 MWF10 C 203 Leauby 25 80421 MGMT 302 04 F 2002 MWF11 C 206 Leauby 25 80422 MGMT 302 05 F 2002 MWF9 C 202 Leauby 25 80423 MGMT 302 06 F 2002 MWF12 C 203 Rhoda 25 80424 MGMT 353 03 F 2002 MWF2 C 203 Rhoda 25 80425 MGMT 354 03 F 2002 MWF10 C 203 Rhoda 25 80426 MGMT 302 07 F 2002 MWF9 C 202 Tavana 25 80427 MGMT 302 08 F 2002 MWF11 C 202 Tavana 25 80428 MGMT 302 09 F 2002 MWF10 C 203 Tavana 25 80429 MKTG 301 01 F 2002 MWF12 C 206 Jones D 25 80430 MKTG 301 02 F 2002 MWF9 C 202 Jones D 25 80431 MKTG 305 01 F 2002 MWF10 C 203 Jones D 25 80432 MKTG 301 03 F 2002 TR9 C 206 Szabat 25 80433 MKTG 301 04 F 2002 MWF10 C 202 Szabat 25 80434 MKTG 304 01 F 2002 MWF9 C 203 Szabat 25 80435 ECN 150 01 F 2002 MWF11 O 113 Mshomba 25 80436 ECN 150 02 F 2002 MWF10 O 325 Mshomba 25 80437 ECN 150 03 F 2002 TR2 O 325 Mshomba 25 80438 ECN 213 01 F 2002 MWF9 O 217 Mshomba 25 80439 ECN 150 04 F 2002 MWF11 O 113 Paulin 25 80440 ECN 213 02 F 2002 TR2 O 113 Paulin 25 80441 ECN 213 03 F 2002 MWF2 O 113 Paulin 25 80442 ECN 213 04 F 2002 MWF9 O 113 Paulin 25 80443 ECN 155 01 F 2002 MWF10 O 217 Robison 25 80444 ECN 155 02 F 2002 MWF11 O 325 Robison 25 80445 ECN 201 01 F 2002 TR3:30 O 113 Robison 25 80446 ECN 201 02 F 2002 MWF9 O 113 Robison 25 80447 ENG 107 01 F 2002 MWF10 O 217 Beatty 25 80448 ENG 108 01 F 2002 MWF9 O 217 Beatty 25 80449 ENG 150 01 F 2002 MWF12 O 123 Beatty 25 80450 ENG 203 01 F 2002 MWF11 O 113 Beatty 25 80451 ENG 107 02 F 2002 MWF2 O 325 Butler 25 80452 ENG 150 02 F 2002 MWF9 O 325 Butler 25 80453 ENG 150 03 F 2002 MWF10 O 113 Butler 25 80454 ENG 107 03 F 2002 TR9 O 217 Millard 25 80455 ENG 108 02 F 2002 MWF9 O 217 Millard 25 80456 ENG 150 04 F 2002 MWF11 O 123 Millard 25 80457 ENG 150 05 F 2002 MWF12 O 113 Millard 25 80458 ENG 107 04 F 2002 MWF10 O 113 Soven 25 80459 ENG 107 05 F 2002 MWF9 O 217 Soven 25 80460 ENG 203 02 F 2002 TR2 O 113 Soven 25 80461 ENG 203 03 F 2002 MWF12 O 217 Soven 25 80462 ENG 107 06 F 2002 MWF9 O 113 Sude 25 SECTI DEPT COU SE SE YEAR TIME ROOM PROFESSOR STOPPOINT JUNK ----- ---- --- -- -- ---------- -------- -------- --------------- ---------- ---------- 80463 ENG 107 07 F 2002 TR2 O 113 Sude 25 80464 ENG 107 08 F 2002 TR9 O 113 Sude 25 80465 MTH 117 01 F 2002 MWF9 O 107 Knappenberger 25 80466 MTH 120 01 F 2002 MWF10 O 107 Knappenberger 25 80467 MTH 120 02 F 2002 MWF11 O 107 Knappenberger 25 80468 MTH 221 01 F 2002 MWF12 O 107 Knappenberger 25 80469 MTH 113 01 F 2002 MWF9 O 109 Andrilli 25 80470 MTH 120 03 F 2002 MWF10 O 109 Andrilli 25 80471 MTH 120 04 F 2002 MWF11 O 109 Andrilli 25 80472 MTH 240 01 F 2002 TR3:30 O 109 Andrilli 25 80473 MTH 120 05 F 2002 MWF9 O 217 DiDio 25 80474 MTH 140 01 F 2002 MWF11 O 123 DiDio 25 80475 MTH 221 02 F 2002 TR9 O 113 DiDio 25 80476 MTH 113 02 F 2002 TR9 O 111 McConnell 25 80477 MTH 113 03 F 2002 MWF9 O 111 McConnell 25 80478 MTH 113 04 F 2002 MWF10 O 111 McConnell 25 80479 MTH 113 05 F 2002 MWF11 O 123 McConnell 25 80480 MTH 113 06 F 2002 MWF9 O 113 Michalek 25 80481 MTH 120 06 F 2002 MWF10 O 217 Michalek 25 80482 MTH 140 02 F 2002 MWF11 O 111 Michalek 25 80483 MTH 240 02 F 2002 MWF12 O 111 Michalek 25 80484 MTH 113 07 F 2002 TR9 O 113 McCarty 25 80485 MTH 140 03 F 2002 MWF9 O 113 McCarty 25 80486 MTH 222 01 F 2002 MWF10 O 113 McCarty 25 80487 PHL 151 01 F 2002 TR2 O 217 Moreau 25 80488 PHL 152 01 F 2002 MWF9 O 113 Moreau 25 80489 PSY 155 01 F 2002 MWF10 O 113 Armstrong 25 80490 PSY 155 01 F 2002 MWF9 O 217 Burke J 25 80491 PSY 155 03 F 2002 MWF12 O 113 Collins 25 80492 PSY 155 02 F 2002 MWF10 O 325 Falcone 25 80493 REL 150 01 F 2002 MWF11 O 113 Kelly G 25 80494 REL 153 01 F 2002 MWF9 O 113 Kelly G 25 80495 REL 150 02 F 2002 MWF10 O 113 Ratkus 25 80496 REL 153 02 F 2002 MWF12 O 113 Ratkus 25 80497 SOC 150 01 F 2002 MWF9 O 217 Nguyen 25 80498 SOC 150 02 F 2002 MWF10 O 113 Stull 25 80499 HIS 151 01 F 2002 TR9 O 113 Sheehy 25 80500 HIS 151 02 F 2002 MWF9 O 325 Sheehy 25 80501 HIS 305 01 F 2002 MWF11 O 113 Sheehy 25 80502 HIS 305 02 F 2002 MWF10 O 113 Sheehy 25 80503 HIS 151 03 F 2002 MWF2 O 113 Fair 25 80504 HIS 151 04 F 2002 MWF9 O 325 Fair 25 80505 HIS 329 01 F 2002 MWF10 O 217 Fair 25 80506 HIS 333 01 F 2002 MWF11 O 123 Fair 25 80507 HIS 251 01 F 2002 TR2 O 113 Desnoyers 25 80508 HIS 251 02 F 2002 MWF9 O 113 Desnoyers 25 80509 HIS 251 03 F 2002 MWF10 O 113 Desnoyers 25 SECTI DEPT COU SE SE YEAR TIME ROOM PROFESSOR STOPPOINT JUNK ----- ---- --- -- -- ---------- -------- -------- --------------- ---------- ---------- 80510 HIS 324 01 F 2002 MWF12 O 217 Desnoyers 25 80511 HIS 151 05 F 2002 TR9 O 113 Leibiger 25 80512 HIS 151 06 F 2002 MWF9 O 113 Leibiger 25 80513 HIS 251 04 F 2002 MWF11 O 113 Leibiger 25 80514 HIS 324 02 F 2002 MWF10 O 113 Leibiger 25 80515 POL 151 01 F 2002 MWF12 O 325 Balchunis 25 80516 POL 151 02 F 2002 MWF11 O 113 Brogan 25 80517 BUS 101 01 F 2002 MWF9 C 203 Brazina 25 80518 BUS 101 02 F 2002 MWF11 O 113 Brazina 25 80519 BUS 200 01 F 2002 MWF9 C 203 Jones D 25 80520 BUS 150 01 F 2002 MWF12 O 113 Szabat 25 80521 BUS 150 02 F 2002 MWF9 C 203 Szabat 25 80522 BUS 200 02 F 2002 MWF11 O 113 Szabat 25 80523 BUS 200 03 F 2002 MWF10 C 203 Brazina 25 81101 CSIT 136 01 F 2002 TR11 O 127 Reichardt 20 81102 CSIT 136 02 F 2002 TR2 O 127 Reichardt 20 81103 CSIT 136 03 F 2002 MW2 O 127 Reichardt 20 81201 CSIT 362 01 F 2002 MWF12 O 107 Kirsch 25 81211 CSIT 371 01 F 2002 T2 H 102 Longo 25 81212 CSIT 371 02 F 2002 M6 H 102 Longo 25 161 rows selected. SQL> select * from sections 2 where room != 'O 129'; SECTI DEPT COU SE SE YEAR TIME ROOM PROFESSOR STOPPOINT JUNK ----- ---- --- -- -- ---------- -------- -------- --------------- ---------- ---------- 11111 CSC 157 01 F 1999 MWF 930 O 111 Redmond 25 11112 CSC 157 02 F 1999 MWF 1130 O 107 Redmond 25 11121 CSC 162 01 F 1999 MWF 1230 O 107 Turk 25 62272 CSC 151 01 F 1996 mw610 bs117 Grant 25 62341 CHEM 111 01 S 1997 mw900 at123 Burke 99 66415 CSC 151 01 S 1997 mw120 bs134 Stevens 35 66416 CSC 151 02 S 1997 tt200 bs134 Stevens 35 66417 CSC 151 40 S 1997 mw610 at123 Mead 35 66418 CSC 151 41 S 1997 mw730 bs117 Grant 35 66419 CSC 152 40 S 1997 tt610 at123 Billa 35 66422 CSC 265 40 S 1997 mw610 fa229 Kolasa 35 67488 CSIT 447 40 S 1997 mw610 fa221 Ma 30 69705 CSIT 365 01 S 1997 mw120 fa229 Redmond 35 70232 CSIT 136 01 S 1997 tt1230 at205 Venkatesan 35 70234 CSIT 136 40 S 1997 tt740 at123 Kolasa 35 70238 CSIT 461 40 S 1997 mw420 bs115 Redmond 30 80101 CSC 151 01 F 2002 MWF8 O 200 Wiley 20 80102 CSC 151 02 F 2002 MWF9 O 127 Wiley 20 80103 CSC 151 03 F 2002 MWF10 O 200 Young 20 80104 CSC 151 04 F 2002 MWF11 O 200 Young 20 80105 CSC 151 05 F 2002 MWF12 O 200 Young 20 80201 CSC 152 01 F 2002 MWF11 H 101 DiDio 20 80202 CSC 152 01 F 2002 MWF12 H 101 DiDio 20 80301 CSC 157 01 F 2002 MWF11R11 O 219 Elliott 25 80311 CSC 162 01 F 2002 MWF12R2 O 217 Turk 25 80321 CSC 264 01 F 2002 MWF9 O 109 Blum 25 80322 CSC 264 02 F 2002 MWF10 O 215 Redmond 25 80323 CSC 264 03 F 2002 R6 O 201 Reichardt 25 80331 CSC 352 01 F 2002 T6 O 200 Turk 25 80341 CSC 354 01 F 2002 MWF11 O 113 Turk 25 80351 CSC 362 01 F 2002 MWF11 O 109 Kirsch 25 80361 CSC 372 01 F 2002 MW2 O 200 Wiley 25 80371 CSC 480 01 F 2002 MW3:30 O 201 Kirsch 25 80402 BIO 157 01 F 2002 MWF10 O 217 Ballough 25 80403 BIO 180 01 F 2002 MWF9 O 325 Ballough 25 80404 BIO 161 01 F 2002 MWF11 O 113 Ballough 25 80405 BIO 210 01 F 2002 MWF12 O 123 Ballough 25 80406 CHEM 111 01 F 2002 MWF10 O 113 Jones N 25 80407 CHEM 150 01 F 2002 TR9 O 113 Jones N 25 80408 CHEM 201 01 F 2002 MWF9 O 325 Jones N 25 80409 CHEM 301 01 F 2002 MWF11 O 113 Jones N 25 80410 CHEM 111 02 F 2002 MWF10 O 217 Shalhoub 25 80411 CHEM 150 02 F 2002 TR2 O 113 Shalhoub 25 80412 CHEM 201 02 F 2002 MWF11 O 325 Shalhoub 25 80413 CHEM 301 02 F 2002 MWF12 O 123 Shalhoub 25 80414 MGMT 302 01 F 2002 MWF2 C 202 Bruce 25 80415 MGMT 353 01 F 2002 MWF9 C 203 Bruce 25 SECTI DEPT COU SE SE YEAR TIME ROOM PROFESSOR STOPPOINT JUNK ----- ---- --- -- -- ---------- -------- -------- --------------- ---------- ---------- 80416 MGMT 353 02 F 2002 MWF11 C 202 Bruce 25 80417 MGMT 302 02 F 2002 MWF10 C 203 Joglekar 25 80418 MGMT 354 01 F 2002 TR9 C 206 Joglekar 25 80419 MGMT 354 02 F 2002 TR3:30 C 202 Joglekar 25 80420 MGMT 302 03 F 2002 MWF10 C 203 Leauby 25 80421 MGMT 302 04 F 2002 MWF11 C 206 Leauby 25 80422 MGMT 302 05 F 2002 MWF9 C 202 Leauby 25 80423 MGMT 302 06 F 2002 MWF12 C 203 Rhoda 25 80424 MGMT 353 03 F 2002 MWF2 C 203 Rhoda 25 80425 MGMT 354 03 F 2002 MWF10 C 203 Rhoda 25 80426 MGMT 302 07 F 2002 MWF9 C 202 Tavana 25 80427 MGMT 302 08 F 2002 MWF11 C 202 Tavana 25 80428 MGMT 302 09 F 2002 MWF10 C 203 Tavana 25 80429 MKTG 301 01 F 2002 MWF12 C 206 Jones D 25 80430 MKTG 301 02 F 2002 MWF9 C 202 Jones D 25 80431 MKTG 305 01 F 2002 MWF10 C 203 Jones D 25 80432 MKTG 301 03 F 2002 TR9 C 206 Szabat 25 80433 MKTG 301 04 F 2002 MWF10 C 202 Szabat 25 80434 MKTG 304 01 F 2002 MWF9 C 203 Szabat 25 80435 ECN 150 01 F 2002 MWF11 O 113 Mshomba 25 80436 ECN 150 02 F 2002 MWF10 O 325 Mshomba 25 80437 ECN 150 03 F 2002 TR2 O 325 Mshomba 25 80438 ECN 213 01 F 2002 MWF9 O 217 Mshomba 25 80439 ECN 150 04 F 2002 MWF11 O 113 Paulin 25 80440 ECN 213 02 F 2002 TR2 O 113 Paulin 25 80441 ECN 213 03 F 2002 MWF2 O 113 Paulin 25 80442 ECN 213 04 F 2002 MWF9 O 113 Paulin 25 80443 ECN 155 01 F 2002 MWF10 O 217 Robison 25 80444 ECN 155 02 F 2002 MWF11 O 325 Robison 25 80445 ECN 201 01 F 2002 TR3:30 O 113 Robison 25 80446 ECN 201 02 F 2002 MWF9 O 113 Robison 25 80447 ENG 107 01 F 2002 MWF10 O 217 Beatty 25 80448 ENG 108 01 F 2002 MWF9 O 217 Beatty 25 80449 ENG 150 01 F 2002 MWF12 O 123 Beatty 25 80450 ENG 203 01 F 2002 MWF11 O 113 Beatty 25 80451 ENG 107 02 F 2002 MWF2 O 325 Butler 25 80452 ENG 150 02 F 2002 MWF9 O 325 Butler 25 80453 ENG 150 03 F 2002 MWF10 O 113 Butler 25 80454 ENG 107 03 F 2002 TR9 O 217 Millard 25 80455 ENG 108 02 F 2002 MWF9 O 217 Millard 25 80456 ENG 150 04 F 2002 MWF11 O 123 Millard 25 80457 ENG 150 05 F 2002 MWF12 O 113 Millard 25 80458 ENG 107 04 F 2002 MWF10 O 113 Soven 25 80459 ENG 107 05 F 2002 MWF9 O 217 Soven 25 80460 ENG 203 02 F 2002 TR2 O 113 Soven 25 80461 ENG 203 03 F 2002 MWF12 O 217 Soven 25 80462 ENG 107 06 F 2002 MWF9 O 113 Sude 25 SECTI DEPT COU SE SE YEAR TIME ROOM PROFESSOR STOPPOINT JUNK ----- ---- --- -- -- ---------- -------- -------- --------------- ---------- ---------- 80463 ENG 107 07 F 2002 TR2 O 113 Sude 25 80464 ENG 107 08 F 2002 TR9 O 113 Sude 25 80465 MTH 117 01 F 2002 MWF9 O 107 Knappenberger 25 80466 MTH 120 01 F 2002 MWF10 O 107 Knappenberger 25 80467 MTH 120 02 F 2002 MWF11 O 107 Knappenberger 25 80468 MTH 221 01 F 2002 MWF12 O 107 Knappenberger 25 80469 MTH 113 01 F 2002 MWF9 O 109 Andrilli 25 80470 MTH 120 03 F 2002 MWF10 O 109 Andrilli 25 80471 MTH 120 04 F 2002 MWF11 O 109 Andrilli 25 80472 MTH 240 01 F 2002 TR3:30 O 109 Andrilli 25 80473 MTH 120 05 F 2002 MWF9 O 217 DiDio 25 80474 MTH 140 01 F 2002 MWF11 O 123 DiDio 25 80475 MTH 221 02 F 2002 TR9 O 113 DiDio 25 80476 MTH 113 02 F 2002 TR9 O 111 McConnell 25 80477 MTH 113 03 F 2002 MWF9 O 111 McConnell 25 80478 MTH 113 04 F 2002 MWF10 O 111 McConnell 25 80479 MTH 113 05 F 2002 MWF11 O 123 McConnell 25 80480 MTH 113 06 F 2002 MWF9 O 113 Michalek 25 80481 MTH 120 06 F 2002 MWF10 O 217 Michalek 25 80482 MTH 140 02 F 2002 MWF11 O 111 Michalek 25 80483 MTH 240 02 F 2002 MWF12 O 111 Michalek 25 80484 MTH 113 07 F 2002 TR9 O 113 McCarty 25 80485 MTH 140 03 F 2002 MWF9 O 113 McCarty 25 80486 MTH 222 01 F 2002 MWF10 O 113 McCarty 25 80487 PHL 151 01 F 2002 TR2 O 217 Moreau 25 80488 PHL 152 01 F 2002 MWF9 O 113 Moreau 25 80489 PSY 155 01 F 2002 MWF10 O 113 Armstrong 25 80490 PSY 155 01 F 2002 MWF9 O 217 Burke J 25 80491 PSY 155 03 F 2002 MWF12 O 113 Collins 25 80492 PSY 155 02 F 2002 MWF10 O 325 Falcone 25 80493 REL 150 01 F 2002 MWF11 O 113 Kelly G 25 80494 REL 153 01 F 2002 MWF9 O 113 Kelly G 25 80495 REL 150 02 F 2002 MWF10 O 113 Ratkus 25 80496 REL 153 02 F 2002 MWF12 O 113 Ratkus 25 80497 SOC 150 01 F 2002 MWF9 O 217 Nguyen 25 80498 SOC 150 02 F 2002 MWF10 O 113 Stull 25 80499 HIS 151 01 F 2002 TR9 O 113 Sheehy 25 80500 HIS 151 02 F 2002 MWF9 O 325 Sheehy 25 80501 HIS 305 01 F 2002 MWF11 O 113 Sheehy 25 80502 HIS 305 02 F 2002 MWF10 O 113 Sheehy 25 80503 HIS 151 03 F 2002 MWF2 O 113 Fair 25 80504 HIS 151 04 F 2002 MWF9 O 325 Fair 25 80505 HIS 329 01 F 2002 MWF10 O 217 Fair 25 80506 HIS 333 01 F 2002 MWF11 O 123 Fair 25 80507 HIS 251 01 F 2002 TR2 O 113 Desnoyers 25 80508 HIS 251 02 F 2002 MWF9 O 113 Desnoyers 25 80509 HIS 251 03 F 2002 MWF10 O 113 Desnoyers 25 SECTI DEPT COU SE SE YEAR TIME ROOM PROFESSOR STOPPOINT JUNK ----- ---- --- -- -- ---------- -------- -------- --------------- ---------- ---------- 80510 HIS 324 01 F 2002 MWF12 O 217 Desnoyers 25 80511 HIS 151 05 F 2002 TR9 O 113 Leibiger 25 80512 HIS 151 06 F 2002 MWF9 O 113 Leibiger 25 80513 HIS 251 04 F 2002 MWF11 O 113 Leibiger 25 80514 HIS 324 02 F 2002 MWF10 O 113 Leibiger 25 80515 POL 151 01 F 2002 MWF12 O 325 Balchunis 25 80516 POL 151 02 F 2002 MWF11 O 113 Brogan 25 80517 BUS 101 01 F 2002 MWF9 C 203 Brazina 25 80518 BUS 101 02 F 2002 MWF11 O 113 Brazina 25 80519 BUS 200 01 F 2002 MWF9 C 203 Jones D 25 80520 BUS 150 01 F 2002 MWF12 O 113 Szabat 25 80521 BUS 150 02 F 2002 MWF9 C 203 Szabat 25 80522 BUS 200 02 F 2002 MWF11 O 113 Szabat 25 80523 BUS 200 03 F 2002 MWF10 C 203 Brazina 25 81101 CSIT 136 01 F 2002 TR11 O 127 Reichardt 20 81102 CSIT 136 02 F 2002 TR2 O 127 Reichardt 20 81103 CSIT 136 03 F 2002 MW2 O 127 Reichardt 20 81201 CSIT 362 01 F 2002 MWF12 O 107 Kirsch 25 81211 CSIT 371 01 F 2002 T2 H 102 Longo 25 81212 CSIT 371 02 F 2002 M6 H 102 Longo 25 161 rows selected. SQL> select * from students 2 where gpa < 3; STUD FIRST M LAST YE MAJO NUMCREDITSEARNED GPA HOMETOWN BALANCEDUE ---- --------------- - --------------- -- ---- ---------------- ---------- -------------------- ---------- 1113 Kenny T Anderson So MGMT 54 2.85 Camden 1000 1116 Allen X Iverson Jr BIO 81 2.87 Maple Shade 3500 1123 Shawn W Bradley Fr CSC 27 2.12 Palmyra 1500 1212 Kobe J Bryant So BIO 31 2.67 Lower Merion 125 1818 Kevin G Garnett Fr BIO 12 1.9 Chicago 0 2121 Keith V Van Horn Sr MGMT 91 2.98 Cherry Hill 100 4141 Glenn B Robinson Jr HIS 70 2.5 Philadelphia 120 5151 Baron U Davis So BIO 32 2.99 Westwood 0 5555 Penny A Hardaway Fr CSC 12 2.31 Cherry Hill 0 9 rows selected. SQL> select * from students 2 where gpa < 3 and gpa >= 2.5; STUD FIRST M LAST YE MAJO NUMCREDITSEARNED GPA HOMETOWN BALANCEDUE ---- --------------- - --------------- -- ---- ---------------- ---------- -------------------- ---------- 1113 Kenny T Anderson So MGMT 54 2.85 Camden 1000 1116 Allen X Iverson Jr BIO 81 2.87 Maple Shade 3500 1212 Kobe J Bryant So BIO 31 2.67 Lower Merion 125 2121 Keith V Van Horn Sr MGMT 91 2.98 Cherry Hill 100 4141 Glenn B Robinson Jr HIS 70 2.5 Philadelphia 120 5151 Baron U Davis So BIO 32 2.99 Westwood 0 6 rows selected. SQL> select * from students 2 where gpa between 3 and 2.5; no rows selected SQL> select * from students 2 where gpa between 2.5 and 3; STUD FIRST M LAST YE MAJO NUMCREDITSEARNED GPA HOMETOWN BALANCEDUE ---- --------------- - --------------- -- ---- ---------------- ---------- -------------------- ---------- 1111 Charles D Barkley Fr HIS 22 3 Pennsauken 0 1113 Kenny T Anderson So MGMT 54 2.85 Camden 1000 1116 Allen X Iverson Jr BIO 81 2.87 Maple Shade 3500 1212 Kobe J Bryant So BIO 31 2.67 Lower Merion 125 2121 Keith V Van Horn Sr MGMT 91 2.98 Cherry Hill 100 4141 Glenn B Robinson Jr HIS 70 2.5 Philadelphia 120 5151 Baron U Davis So BIO 32 2.99 Westwood 0 7 rows selected. SQL> select * from sections 2 where room is null; no rows selected SQL> select * from catalogcourses; DEPT COU TITLE ---- --- ------------------------------ DESCRIPTION CREDITS ---------------------------------------------------------------------------------------------------- ---------- BIO 157 Life Science: An environmental A foundation biology course for non-majors 3 BIO 158 Life Science: A Human approach A foundation biology course for non-majors, that places emphasis on human biology 3 BIO 161 Anatomy and Physiology How human bodies work, great for pre-meds 4 BIO 162 Anatomy and Physiology II More fun for pre-meds 4 BIO 163 Clinical Microbiology Germs and killing them 4 BIO 180 Intro to Biology An introduction to biology for biology and chemistry majors 3 BIO 210 Cellular Biology and Genetics Basic Biochemistry, DNA, genes 4 BIO 230 Diversity, Evolution and Ecolo The environment and evolution 4 BUS 101 Intro to Financial Reporting Accounting without software packages 3 BUS 150 Presentation Skills for Busine Giving Talks, using PowerPoint 3 BUS 200 Fundamentals of Financial Mana Time value of money, security valuation, cost of capital, financial statement analysis 3 CHEM 111 Intro to Chemistry An introduction to chem for real science majors … 4 CHEM 112 General Chemistry II All the way up through quantum mechanics 4 CHEM 150 Consumer Chemistry Chemistry in society - no math, hardly any lab 3 CHEM 201 Organic Chemistry Weed out course for pre-meds 4 DEPT COU TITLE ---- --- ------------------------------ DESCRIPTION CREDITS ---------------------------------------------------------------------------------------------------- ---------- CHEM 202 Organic Chemistry II You still here? 4 CHEM 301 Physical Chemistry Quantum Mechanics applied to the solution of elementary systems. Lasers too! 4 CHEM 302 Physical Chemistry II Thermodynamics and kinetics, chemical equilibrium, thermochemistry 4 CSC 151 Intro to Computing Introduces basic packages such as Word, Excel 3 CSC 152 Intro to Computing, Math / Sci Introduces basic packages such as Word, Excel - emphasis on Excel 3 CSC 157 Problem Solving and Programmin Learning Programming and Problem-solving using the computer language Java as a vehicle. 4 CSC 162 DataStructures C++ introduction plus introductory algorithms - searching and sorting etc 4 CSC 264 Database Systems Intro to Database systems including relational theory and applications 3 CSC 265 PC Applications Applications for PCs, especially using Visual Basic 3 CSC 352 Computers, Ethics, and Social Privacy, cryptography, hackers, ethics 3 CSC 354 Data Structures Advanced data structures and intro to analysis of algorithms 3 CSC 360 Internship Appropriate industrial experience 3 CSC 362 Networks Communication networks and cooperative processing. LANs WANS 3 CSC 366 Language Theory and Design Theory, finite automata, BNF, syntax, semantics, language paradigms 3 CSC 372 Database Applications Database systems in an N-tier world 3 DEPT COU TITLE ---- --- ------------------------------ DESCRIPTION CREDITS ---------------------------------------------------------------------------------------------------- ---------- CSC 453 Graphics Picture generation, 2D, 3D, transformations 3 CSC 456 Intro to Artificial Intelligen Knowledge representation, search, heuristic systems and … 3 CSC 457 Operating Systems General Principles and Concepts of process and resource management in OS 3 CSC 464 Theory of Algorithms Analysis of algorithms. Divide and Conquer, greedy, backtracking, dynamic programming, NP complete 3 CSC 480 Project Design Project oriented - requirements analysis, design, prototyping 3 CSC 481 Project Implementation Project oriented - development, testing, change management 3 CSD 210 Creating Multimedia Planning, designing and creating multimedia content. Integration into WWW 3 CSD 340 Web Scripting Creation of dynamic and interactive documents for the internet 3 CSIT 136 Intro to IT Hardware and Software componenets of a computing system 3 CSIT 362 Networking Networking for IT majors 3 CSIT 365 Client Support Help desk, installation and support 3 CSIT 371 Security Principles and Practice of Computer Security, including internet security 3 CSIT 382 LANs and Network Admin A practical approach to network administration using current technologies 3 CSIT 392 Groupware Systems developed to support group cooperation and work 3 CSIT 447 Applied Operating Systems Principles of process and resource management in OS and their application 3 DEPT COU TITLE ---- --- ------------------------------ DESCRIPTION CREDITS ---------------------------------------------------------------------------------------------------- ---------- CSIT 461 Telecommunications and Telepho Telephone network architecture, local loop, PBX and Centrex, ISDN, ATM 3 ECN 150 Macroeconomics National and International economics 3 ECN 155 Modern Economic Issues Markets. Plus special topics 3 ECN 201 Microeconomics Business firm and market analysis 3 ECN 213 Stats for Economics No proofs, econ examples 3 ENG 107 College Writing Grammar, Organization, Expository Writing 3 ENG 108 College Writing II Planning and Executing Writing Assignments - especially about readings, or using library research 3 ENG 150 Themes in Literature Read, Write, Think about primary texts (at least two genres) 3 ENG 203 Fiction Reading, analysis and discussion of prose fiction 3 HIS 151 Global History to 1500 Dinosaurs, Serfs, No computers 3 HIS 251 Global History 1500 to Present Wars, Rumors of Wars 3 HIS 305 US 1877 to Present Post Reconstruction, Modern Era, Superpower! 3 HIS 324 History of Philadelphia From William Penn to John Street 3 HIS 329 The American Woman Women's rights, industrial revolution, Women in War 3 HIS 331 America's Military Past Wars, Rumors or Wars, Miltary Industrial Complex, Weapons of Mass Destruction 3 DEPT COU TITLE ---- --- ------------------------------ DESCRIPTION CREDITS ---------------------------------------------------------------------------------------------------- ---------- HIS 333 The American Imigrant like it says 3 HIS 337 The Black Experience Slavery, Civil Rights, 3 MGMT 302 Managing Human Resources creating a competitive workforce 3 MGMT 303 Managing Human Resources II Developing and Managing a competive workforce 3 MGMT 353 Dispute Resolution Conflict management, negotiation 3 MGMT 354 Entrepreneurship Small business management 3 MKTG 301 Personal Selling Sales presentations, lying, networking 3 MKTG 302 Advertising and Promotional Ma Advertising copy, ad agencies, measuring effectiveness 3 MKTG 304 Business to Business Marketing Organizational and interfunctional interaction, buyer behavior, global interdependence 3 MKTG 305 International Marketing like it says, complexities of marketing internationally 3 MTH 113 Algebra and Trig like it says 4 MTH 117 Calculus Calculus for people who dont like theorums 3 MTH 118 Multi-variable Calculus Calculus for business majors 3 MTH 120 Calculus Serious calculus for Math and Science majors 4 MTH 140 Discrete Math Extra Math for Computer Science Majors 3 DEPT COU TITLE ---- --- ------------------------------ DESCRIPTION CREDITS ---------------------------------------------------------------------------------------------------- ---------- MTH 221 Calculus II More serious calc 4 MTH 222 Calculus III 3D, partial differentiation and multiple integration 4 MTH 240 Linear Algebra Matrices, eigenvectors, with applications 3 PHL 151 The Human Person Patterns course 3 PHL 152 Moral Choice More interesting patterns course 3 POL 151 American Government Money Talks 3 PSY 155 Intro to Psychology How people work 3 REL 150 The Christian Tradition Patterns course 3 REL 153 Dynamics of Religion Patterns course 3 SOC 150 Principles of Sociology People in groups / society, Frameworks course 3 85 rows selected. SQL> describe catalogcourses Name Null? Type ----------------------------------------------------------------- -------- -------------------------------------------- DEPT NOT NULL CHAR(4) COURSE NOT NULL CHAR(3) TITLE VARCHAR2(30) DESCRIPTION VARCHAR2(100) CREDITS NUMBER(38) SQL> select dept, course, title, credits 2 from catalogcourses 3 where title like '%Lang%'; DEPT COU TITLE CREDITS ---- --- ------------------------------ ---------- CSC 366 Language Theory and Design 3 SQL> select dept, course, title, credits 2 from catalogcourses 3 where title like '%lang%'; no rows selected SQL> spool off SQL> select * from enrollments 2 where sectionid = '66415' 3 or sectionid = '66419'; SECTI STUD SPECIALP GR ----- ---- -------- -- 66415 1111 134556 B 66415 1116 A 66415 1123 B 66415 5555 C 66419 1093 D 66419 1111 C 66419 1115 F 66419 1116 B 66419 1119 C 9 rows selected. SQL> select * from enrollments 2 where sectionid in ( '66415','66419'); SECTI STUD SPECIALP GR ----- ---- -------- -- 66415 1111 134556 B 66415 1116 A 66415 1123 B 66415 5555 C 66419 1093 D 66419 1111 C 66419 1115 F 66419 1116 B 66419 1119 C 9 rows selected. SQL> select *, 2 capacity / numbstudentworkstations 3 as ratio 4 from rooms; select *, * ERROR at line 1: ORA-00923: FROM keyword not found where expected SQL> select rooms.*, 2 capacity / numbstudentworkstations 3 as ratio 4 from rooms; capacity / numbstudentworkstations * ERROR at line 2: ORA-01476: divisor is equal to zero SQL> select rooms.*, 2 capacity / numbstudentworkstations 3 as ratio 4 from rooms 5 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> select avg(gpa) from students; AVG(GPA) ---------- 3.0635 SQL> select max(gpa) from students; MAX(GPA) ---------- 3.87 SQL> select min(gpa) from students; MIN(GPA) ---------- 1.9 SQL> select count(*) from students; COUNT(*) ---------- 20 SQL> select count(*) from students 2 where major = 'CSC'; COUNT(*) ---------- 4 SQL> select count(distinct major) 2 from students; COUNT(DISTINCTMAJOR) -------------------- 6 SQL> select major, avg(gpa) 2 from students; select major, avg(gpa) * ERROR at line 1: ORA-00937: not a single-group group function SQL> select major, avg(gpa) 2 from students 3 group by major; MAJO AVG(GPA) ---- ---------- HIS 3.12333333 CHEM 3.38666667 MGMT 2.97666667 BIO 2.706 CSC 2.9525 MKTG 3.735 6 rows selected. SQL> select time, sum(stoppoint) from 2 sections 3 group by time; TIME SUM(STOPPOINT) -------- -------------- mw610 125 MW2 45 MWF2 125 TR3:30 75 TR11 20 T2 25 MWF 930 25 MWF9 865 MW3:30 45 mw420 30 MWF8 20 MWF11 665 R6 25 tt1230 35 MWF10 745 MWF12 415 MWF11R11 25 mw120 70 tt740 35 MWF 1130 25 MWF 1230 25 mw900 99 tt610 35 T6 25 TR9 250 M6 45 tt200 35 mw730 35 MWF12R2 25 TR2 195 30 rows selected. SQL> select time, 2 sum(stoppoint) as total from 3 sections 4 group by time 5 order by total desc; TIME TOTAL -------- ---------- MWF9 865 MWF10 745 MWF11 665 MWF12 415 TR9 250 TR2 195 MWF2 125 mw610 125 mw900 99 TR3:30 75 mw120 70 MW3:30 45 MW2 45 M6 45 tt1230 35 mw730 35 tt200 35 tt610 35 tt740 35 mw420 30 MWF 1230 25 T2 25 MWF 930 25 T6 25 MWF 1130 25 MWF12R2 25 MWF11R11 25 R6 25 MWF8 20 TR11 20 30 rows selected. SQL> select major, avg(gpa), 2 max(gpa), min(gpa) 3 from students 4 group by major; MAJO AVG(GPA) MAX(GPA) MIN(GPA) ---- ---------- ---------- ---------- HIS 3.12333333 3.87 2.5 CHEM 3.38666667 3.85 3.1 MGMT 2.97666667 3.1 2.85 BIO 2.706 3.1 1.9 CSC 2.9525 3.87 2.12 MKTG 3.735 3.82 3.65 6 rows selected. SQL> spool off SQL> select time, 2 sum(stoppoint) as total from 3 sections 4 group by time 5 order by total desc; TIME TOTAL -------- ---------- MWF9 865 MWF10 745 MWF11 665 MWF12 415 TR9 250 TR2 195 MWF2 125 mw610 125 mw900 99 TR3:30 75 mw120 70 MW3:30 45 MW2 45 M6 45 tt1230 35 mw730 35 tt200 35 tt610 35 tt740 35 mw420 30 MWF 1230 25 T2 25 MWF 930 25 T6 25 MWF 1130 25 MWF12R2 25 MWF11R11 25 R6 25 MWF8 20 TR11 20 30 rows selected. SQL> select time, 2 sum(stoppoint) as total from 3 sections 4 where stoppoint > 100 5 group by time 6 order by total desc; no rows selected SQL> select time, 2 sum(stoppoint) as total from 3 sections 4 group by time 5 order by total desc 6 having stoppoint > 100; having stoppoint > 100 * ERROR at line 6: ORA-00933: SQL command not properly ended SQL> select time, 2 sum(stoppoint) as total from 3 sections 4 group by time 5 having stoppoint > 100 6 order by total desc; having stoppoint > 100 * ERROR at line 5: ORA-00979: not a GROUP BY expression SQL> select time, 2 sum(stoppoint) as total from 3 sections 4 group by time 5 having sum(stoppoint) > 100 6 order by total desc; TIME TOTAL -------- ---------- MWF9 865 MWF10 745 MWF11 665 MWF12 415 TR9 250 TR2 195 mw610 125 MWF2 125 8 rows selected. SQL> select time, count(*) as numsect 2 sum(stoppoint) as total from 3 sections 4 group by time 5 having count(*) > 2 6 order by total desc; sum(stoppoint) as total from * ERROR at line 2: ORA-00923: FROM keyword not found where expected SQL> select time, count(*) as numsect, 2 sum(stoppoint) as total from 3 sections 4 group by time 5 having count(*) > 2 6 order by total desc;\ 7 SQL> select time, count(*) as numsect, 2 sum(stoppoint) as total from 3 sections 4 group by time 5 having count(*) > 2 6 order by total desc; TIME NUMSECT TOTAL -------- ---------- ---------- MWF9 35 865 MWF10 30 745 MWF11 27 665 MWF12 17 415 TR9 10 250 TR2 8 195 MWF2 5 125 mw610 4 125 TR3:30 3 75 9 rows selected. SQL> SQL> select avg(gpa) from students; AVG(GPA) ---------- 3.0635 SQL> select studentid, last, first, gpa 2 from students 3 where gpa > 4 select avg(gpa) from students; select avg(gpa) from students * ERROR at line 4: ORA-00936: missing expression SQL> select studentid, last, first, gpa 2 from students 3 where gpa > 4 (select avg(gpa) from students); STUD LAST FIRST GPA ---- --------------- --------------- ---------- 1011 Kidd Ason 3.1 1093 Webber Chris 3.51 1115 O'Neal Shaq 3.82 1117 Hill Grant 3.87 1119 Camby Marcus 3.21 2222 Hughes Larry 3.1 3131 Battier Shane 3.85 6161 Jordan Michael 3.65 7070 Duncan Tim 3.87 7171 Pierce Paul 3.1 10 rows selected. SQL> select studentid, last, first, gpa 2 from students 3 where gpa > 4 (select avg(gpa) from students) 5 order by gpa desc; STUD LAST FIRST GPA ---- --------------- --------------- ---------- 7070 Duncan Tim 3.87 1117 Hill Grant 3.87 3131 Battier Shane 3.85 1115 O'Neal Shaq 3.82 6161 Jordan Michael 3.65 1093 Webber Chris 3.51 1119 Camby Marcus 3.21 7171 Pierce Paul 3.1 1011 Kidd Ason 3.1 2222 Hughes Larry 3.1 10 rows selected. SQL> spool off SQL> select studentid from students 2 where year = 'Fr'; STUD ---- 1111 1123 1818 3131 5555 SQL> select distinct sectionid 2 from enrollments 3 where studentid in 4 (select studentid from students 5 where year = 'Fr'); SECTI ----- 11111 62272 62341 66415 66419 66422 70232 70234 70238 80104 80202 80301 80311 80321 80403 80406 80410 80435 80436 80447 80448 80451 80463 80469 80470 80474 80491 80494 80496 80503 80511 31 rows selected. SQL> select distinct dept, course 2 from sections,enrollments 3 where enrollments.sectionid 4 = sections.sectionid 5 and studentid in 6 (select studentid from students 7 where year = 'Fr'); DEPT COU ---- --- CSC 265 ENG 107 MTH 113 CSC 162 REL 153 CSIT 136 MTH 140 PSY 155 CSC 151 CSIT 461 ECN 150 HIS 151 CSC 157 CHEM 111 MTH 120 CSC 264 ENG 108 CSC 152 BIO 180 19 rows selected. SQL> spool off