LAB 2
Retrieve Records from a database : Course in Votey 303 on Wednesday
SELECT `Subj`,`Title`,`Comp Numb`,`Sec`,`Attr`,`Max Enrollment`,`Current Enrollment`,`Start Time`,`End Time`,`Days`,`Credits`,`Bldg`,`Room`,`Instructor`,`Email` FROM `tblEnrollments` WHERE `Days` LIKE '%M%' AND `Bldg` LIKE 'Votey' AND `Room` LIKE '303' ORDER BY `tblEnrollments`.`Start Time` ASC
| Subject | Title | Course ID | Section | Mode | Seats Stat | Time | Days | Credit | Location | Instructor | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ENGS | Documentary Essay | 93403 | A | INPR | 22 | 22 | 09:40 ～ 10:30 | M W F | 3 | VOTEY 303 | Bottoms, Greg Todd | Greg.Bottoms@uvm.edu |
| STAT | QR: Elements of Statistics | 95134 | D | MIXD | 39 | 48 | 10:50 ～ 11:40 | M W F | 3 | VOTEY 303 | Martin, Jacob William | Jacob.W.Martin@uvm.edu |
| STAT | D2:QR: Stat & Social Justice | 95128 | B | MIXD | 38 | 44 | 13:10 ～ 14:00 | M W F | 3 | VOTEY 303 | Benway, Karen | Karen.Benway@uvm.edu |
| CS | QR: Database Design for Web | 91104 | A | MIXD | 34 | 43 | 14:20 ～ 15:10 | M W F | 3 | VOTEY 303 | Erickson, Robert M. | Robert.Erickson@uvm.edu |
| Sources | UVM Course Enrollment | ||||||||||