SQL

Key to Transcript is: (CrsCode, Semester,section) Transcript StudId CrsCode Semester Section Grade 666666666 MGT123 F1994 S1991 F1997 F1995 F1994 S1997 123454321 CS305 1996 S1996 F1995 S1996 F1997 F1997 EE101 666666666 MAT123 CS305 987654321 MGT123 CS315 987654321 2 123454321 123454321 MAT123 23456789 EE101 CS305 2 023456789 2 2 321001234 MGT123 876006789 GT123 F1997 F19944 Key to Teaching is: (Crscode, Semester, Section) Teaching Prod 009406321 121232343 5556667m 864297531 101202303 900120450 121232343 101202303 900120450 783432188 009406321 CrsCode MGT123 EE101 305 MGT123 CS315 MAT123 Semester F1994 S1991 F1995 F1994 S1997 S1996 F1995 S1996 F1997 F1997 F1997 Section EE101 CS305 AT123 MGT123 MGT123 Key to Professor is: Id Professor Id DeptIdMentorId SalaryAge 6500050 45 Name 783432188 121232343 864297531 Qi Chen Adrian Jones Qi Chen Jacob Taylor John SmythCS555666777 00940621 864297531 EE MAT 75000 60 CS80000 009406321 900120450 987654321 MGT MAT CS 90000 65000 37 Ann White Albert Tnav Key to Course is: CrsCode CrsCodeDeptId CS305 CS315 MGT123 EE101 MATI 23 | MAT CrsName Database Systems Transaction Processing Electronic Circuits Descr High-Paying Job Recover Worst Crashes Get Rich Quick Build Your Own What Started It All cs CS MGT Key to Student is: Id Student Address 1 Lake St Fox 5 TV Gpa Age 2.50 3.00 Id Name MajorStatus 111223344 Mary Smith 987654321 Bart Simpson MGT 24 cs Freshman 123 Main St. 3.50 26 2.75 40 Senior Homer 023456789 Simpson MGT Senior Fox 5 TV 666666666 Joseph Public CS Sophomore 666 Hollow Rd. 3.75 2.55 3.50 3.00 21 123454321 Joe Blow 321001234 Walter White cs Senior 876006789 Jesse PinkmanCS Sophomore5 Adobe Ct. 3 Junior 6 Yard Ct 10 Albug Ln. 19 1) Provide a query that returns the list of all professors by name who taught in fall 1994. Display the professor's name as: Professor Name 2) Find the names of the courses taught in fall 1995 together with the names of the professors who taught those courses 3) Find all students (by student id) who took at least two courses. Hint: these are courses where StudIds are the same and CrsCodes are different) 4) List the students by Studid who took courses both in spring 1991 and fall 1997. (Do this query by two different methods one of the methods must involve a set operation). 5) List all professors who are working for the CS or EE departments. Perform this using two distinct query types. (One of the types must involve a set operation) 6) Find the names of the professors and names of the courses they taught in which Bart Simpson was a student in fall of 1994. (This query involves all 5 tables) 7) Find all professors who have mentors. 8) Find all professors who do not have mentors 9) Who are the professors who have mentors who are in different departments than the professors are in