LAB 3
Retrieve Records from a database : Course in Votey 303 on Wednesday
SELECT `pfkStudentNetId`,`pfkEnrollmentId`,`pmkNetId`,`fldLastName`,`fldFirstName`,`fldMiddleName`,`pmkEnrollmentId`,`Subj`,`#`,`Title`,`Start Time`,`End Time`,`Days`,`Bldg`,`Room`,`Instructor`FROM`tblStudentEnrollments`JOIN `tblStudents` ON `pmkNetId` = `pfkStudentNetId`JOIN `tblEnrollments` ON `pmkEnrollmentId` =`pfkEnrollmentId`WHERE`pfkStudentNetId` LIKE 'yxue'
| Name | Subj | # | Title | Days | Time(Start ~ End) | Location(Building + Room) | Instructor |
|---|---|---|---|---|---|---|---|
| Kamiku Xue | STAT | 151 | QR: Applied Probability | T R | 10:05 ～ 11:20 | REMOTE COURSE | Single, Richard |
| Kamiku Xue | MUL | 033 | Private Lessons:Piano | TBA ～ | REMOTE COURSE | Dickerson, Melissa B | |
| Kamiku Xue | JAPN | 001 | Elementary Japanese I | M W | 15:30 ～ 17:20 | L/L CM 314 | Ueno, Natsumi |
| Kamiku Xue | CS | 148 | QR: Database Design for Web | M W F | 14:20 ～ 15:10 | VOTEY 303 | Erickson, Robert M. |
| Kamiku Xue | CS | 124 | QR: Data Struc & Algorithms | M W F | 13:10 ～ 14:00 | TERRIL 308 | Dion, Lisa |
| Kamiku Xue | CS | 121 | QR: Computer Organization | M W F | 10:50 ～ 11:40 | REMOTE COURSE | Eddy, James Robert |
| Sources | UVM Course Enrollment | ||||||