a cSDP404 Spring 2019 HW04 [Compatibility Mode ces Mailings Review View Emphasis Heading 1 Norm 1) Find the student name and GPA of all students whose last name is simpson or Doe. 2) List professor names and salary to age ratio ordered by salary to age ratio. the salary to age ratio as.SALARY TO AGE Display 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). not use aggregate functions or suqueries, but do use a set operation) 7) What CS professor 8) In one query, find the names of professors or students whose last names begin with D 9) You suspect that there may some identity theft activity at the university, i.e. a student has not taught a course? (use only techniques in SS1) posing as a professor or vice versa. Write a query to find the possible perpetrators. United States) CSDP404 Spring 2019 HW04 [Compatibility Mode) References Mailings Review View Emphasis Heading 1 I V-university-Datanase. Key to Transcript is: ..Crscode Semester section) Transcript StudId CrscedeSemester Section Grade F1 666666666 EE101 MAT12 987654321 | 5305 S1991 FI F1995 23 F1994 S1997 123454321 CS315 123454321 MAT123 1996 1995 51996 1997 11 IMATI 23 | F1997 EE101 023456789 | 5305 321001234 MGT123 F1997 Key to Teaching is..Crscode. Senester.section) Profld 121232343 864297531 900120450 101202303 783432188 CesCode SemesterSection F1994 1991 1995 F1994 MGT123 MAT123 $1996 51996 F1997 C5305 T12 MGT123 English (United States) Times New R....14 A A AS BI 1 .abe x.x2 A' e.A., Emphasis Heading 1 Normal Strong Key to Professor is: Id Menter Id 783432188 864297531 009406321 987654321 Adrian Jones MGT 60000 45 Chen 75000 Jacob Taylor 37 90000 Key to Course is: CrxCode Cs CS315 CS Transoction Recover Worst Crashas EE101 Electronic Circuits Build Your Own Key to Student is: ld Id Nome Major Status 987654321 Bart Simpson STSenier Fax 5 TV 3.00 24 023456789 Homer MST Senior Fox 5 TV 2.75 Tee Blow 6 Yard Ct 2.55 21 87600679JessE 5Adebe C 3.00 ds English (United States)