Question: Question 3 8 pts Student'snum:integer, sname: string, major:string, level: string, age: integer) Class(name: string, meets at: string, room: string, fid: integer) Enrolled(snum: integer, cname: string)

Question 3 8 pts Student'snum:integer, sname: string, major:string, level: string, age: integer) Class(name: string, meets at: string, room: string, fid: integer) Enrolled(snum: integer, cname: string) Faculty(fid:integer, fname: string, deptid: integer) The meaning of these relations is straightforward, for example, Enrolled has one record per student-class pair such that the student is enrolled in the class. Write the following queries in SQL. No duplicates should be printed in any of the answers. For all levels except JR, print the level and the average age of students for that level
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
