SQL

Please answer all 9 questions

Key to Transeript is: (CrsCode,Semester, Section) Transcript CrsCode Semester Section Grade StudId 666666666-| MGT123 1-F1994 S1991 EE101 666666666 MAT F1995 1994 S1997 2 987654321 987654321 123454321 123454321 123454321 MAT123 023456789 EE101 023456789 CS305 12 CS315 S1996 CS305 S1996 2 123 321001234 MGT123 F1997 F1997 F1997 876006789 MGT123 F1994 Key to Teaching is: (Crscode, Teaching Semester, Section) Section CrsCode T123 EE101 CS305 MGT123 ProfId Semester 321 121232343 555666777 864297531 S1991 F1995 F1994 101202303 C5315 900120450 121232343 101202303 1204 783432188 009406321 S1996 F1995 S1996 1997 F1997 F1997 MAT123 101 CS305 AT123 MGT123 MGT123 Key to Professor is: Id Professor Id 783432188 864297531 009406321 987654321 DepfId MentorId Salary Ag Adrian Jones Qi Chen Jacob Taylor Albert Tnav MGT 00940621 MAT 75000 MGT 90000 37 CS Key to Course is: CrsCode CrsCode DeptId CS305 C5315 cs Database Systems Transaction Processing High-Paying Job Recover Worst Crashes Get Rich Quick cs EE101 Electronic Circuits Build Your Own What Started It Key to Student is: Id Student epa Age Id 111223344 Mary Smith CS Freshman 1 Lake St. 2.50 987654321 Bart Simpson MGT Major Status 24 26 2.75 40 Senior Fox 5 TV 3.00 023456789Simpson 666666666 Joseph Public CS Sophomore 666 Hollow Rd. 3.75 123454321 Joe Blow 321001234 Walter White CS Senior 10 A 876006789 Jesse Pinkman CsSophomore 5 Adobe Ct. 3.00 19 Fox 5 TV GT Senior Junior 6 Yard Ct 2.55 21 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). (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 SSl) 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 posing as a professor or vice versa. Write a query to find the possible perpetrators