MySQL

Key to Transcript is: (Crscode. Semester Section) Section Grade StudId 666666666 666666666 666666666 987654321 987654321 123454321 123454321 123454321 023456789 023456789 111111111 111111111 111111111 321001234 876006789 Transcript CrsCode Semester MGT123 F1994 EE101 S1991 MAT123 F1997 CS305 F1995 MGT123 F1994 CS315 S1997 CS305 S1996 MAT123 S1996 EE101 F1995 CS305 S1996 EE101 F1997 MAT123 F1997 MGT123 F1997 MGT123 F1997 MGT123 F1994 w WA AWNAW N ww N N Key to Teaching is: (CrsCode, Semester, Section) Section Prof Id 009406321 121232343 555666777 864297531 101202303 Teaching CrsCode Semester MGT123 F1994 EE101 S1991 CS305 F1995 MGT123 F1994 CS315 $1997 MAT123 EE101 F1995 CS305 MAT123 F1997 MGT123 F1997 MOT123 F1997 20450 m 121232343 101202303 900120450 783432188 009406321 MAT123s1996 S305S19962 Key to Professor is: Id Professor Deptid Salary Mentor Id 555666777 00940621 864297531 Id 101202303 783432188 121232343 864297531 555666777 009406321 900120450 987654321 Name John Smyth Adrian Jones David Jones Qi Chen Mary Doc Jacob Taylor Ann White Albert Troy MGT BE MAT 50000 7500060 80000 9000037 CS MGT 65000 90000 Key to Course is: CrsCode Deptid SrsCode CS305 CS315 MGT123 EE101 MAT123 CrsName Database Systems Transaction Processing Market Analysis Electronic Circuits Descr. High-Paying Job Recover Worst Crashes Get Rich Quick Build Your Own What Started It All EE Key to Student is: Id Student Id Name 111223344 Mary Smith 987654321 Bart Simpson 111111111 John Doe 023456789 Homer Simpson 666666666 Joseph Public 123454321 Joe Blow 321001234 Walter White 876006789 Jesse Pinkman Major CS MGT CS MGT CS EE CS CS Status Freshman Senior Freshman Senior Sophomore Junior Senior Sophomore Address 1 Lake St. Fox 5 TV 123 Main St. Fox 5 TV Goa 2.50 3.00 3.50 2.75 22 21 666 Hollow Rd. 6 Yard Ct. 10 Albug Ln. 5 Adobe Ct. 3.75 2.55 3.50 3.00 19 3) Find the non-CS students with GPAs above 3.00 who have not taken a CS course from Mary Doe. 4) Find students who have taken CS courses but are not CS majors. 5) Find the names of students who are older than some other student. (do not use aggregate functions or subqueries, but do think about using two copies of the same table in the FROM). 6) Find the name(s) of the youngest student(s). (do not use aggregate functions or subqueries, but do use a set operation). 7) What CS professor has not taught a course? (use only techniques in SSI) 8) In one query, find the names of professors or students whose last names begin with D