Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Instructor Table: Student Table: Write the SQL Query statements for the following: Find the IDs of students whove taken CS-101 but have not taken any
"Instructor" Table:
"Student" Table:
Write the SQL Query statements for the following:
Find the IDs of students whove taken CS-101 but have not taken any other CS courses (LIKE CS%).
Find the name of the student who got the most A grades.
Find the department with the highest average salary.
ID name dept-name salary Edit Copy XDelete 10101 Srinivasan Comp. Sci. 65000.00 Finance90000.00 Edit Copy XDelete 15151Mozart Music 40000.00 Edit Copy XDelete 22222 EinsteinPhysics95000.00 Edit Copy X Delete 32343 El Said History 60000.00 Edit Copy XDelete 33456 Gold Physics87000.00 Edit CopyXDelete 45565 Katz Comp. Sci. 75000.00 Edit CopyXDelete 58583 Califieri History 62000.00 Edit Copy X Delete 76543 Singh Finance 80000.00 Edit.. Copy> Edit-.. Copy X Delete 12121 WuStep 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
XML Data Management Native XML And XML Enabled Database Systems
Authors: Akmal Chaudhri, Awais Rashid, Roberto Zicari, John Fuller
1st Edition
