Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

DB2 11 The Database For Big Data And Analytics

Authors: Cristian Molaro, Surekha Parekh, Terry Purcell, Julian Stuhler

1st Edition

1583473858, 978-1583473856

More Books

Students also viewed these Databases questions