Question: Q2. (SQL): Given SIS database, write an appropriate SQL query for each of the followings: a) Find the departement ID that contains a student who


Q2. (SQL): Given SIS database, write an appropriate SQL query for each of the followings: a) Find the departement ID that contains a student who gets the highest grade (using operators: EXISTS, NOT EXISTS, IN, NOT IN, ALL or ANY). Copy the answer from SQL SERVER and paste it below: b) Find for each course ID, the grades average of students. Copy the answer from SQL SERVER and paste it below: SIS Database yes Department DeptiD DeptName EE Electrical Engineering HIST History CLIS Information Studies no Student StdID Name Proficiency Payment Deptid 1 John 75 EE 2 Kathy 92 no HIST 3 Chris 72 Yes HIST 4 John 98 EE Enrollment Course StdID CrsID Grade 1 Ibsc690 90 1 ee750 95 2 Ibsc690 80 2 hist405 60 3 hist405 75 4 ee600 70 CrsID CrsName Ibsc690 Information Technology ee 750 Communication hist405 American History Student Std D Name Proficiency Payment Deptid Department DeptID DeptName Enrollment StdID CrsID Grade Course CrsID CrsName
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
