Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started