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 foreach of the followings: a) Find the departement ID that contains a

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!