Question: Write the following queries in SQL, using the university schema. a. Find the ID and name of each student who has taken at least one

Write the following queries in SQL, using the university schema.

a. Find the ID and name of each student who has taken at least one Comp. Sci. course; make sure there are no duplicate names in the result.

b. Find the ID and name of each student who has not taken any course offered before 2017.

c. For each department, find the maximum salary of instructors in that department. You may assume that every department has at least one instructor.

d. Find the lowest, across all departments, of the per-department maximum salary computed by the preceding query.

Step by Step Solution

★★★★★

3.38 Rating (151 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

a SELECT DISTINCT sid sname FROM Student s JOIN Enrolled e ON sid estudent JOIN Course c ON ec... View full answer

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 Database System Concepts Questions!

Q:

Write the following queries in SQL, using the university schema. (We suggest you actually run these queries on a database, using the sample data that we provide on the web site of the book, db...

Q:

Write the following queries in relational algebra, using the university schema. a. Find the ID and name of each instructor in the Physics department. b. Find the ID and name of each instructor in a...

Q:

Write the following queries in SQL: a. Display a list of all instructors, showing each instructors ID and the number of sections taught. Make sure to show the number of sections as 0 for instructors...

Q:

Write the following queries in SQL, using the university schema. a. Find the names of all studentswho have taken at least one Comp. Sci. course; make sure there are no duplicate names in the result....

Q:

Do not answer if you cannot answer all of them. Problem 2. Answer 2.1-2.3 using university schema classroom (building, room number, capacity) department (dept name, building, budget) course (course...

Q:

Q3: Write the following queries in SQL, using the university schema. classroom(building, room number, capacity) department(dept name, building, budget) course(course id, title, dept name, credits)...

Q:

Write the following queries in SQL, using the university schema. classroomfbuilding, room number, capacity) departmentfdept name, building, budget) course(course id, title, dept name, credits)...

Q:

SOLVE IN SQL PLEASE :) classroom(building, roomnumber, capacity) department(dept_name, building, budget) course(course_id, title, dept_name, credits) instructor(ID, name, dept_name, salary) section...

Q:

Write the following queries in SQL, using the university schema. Find the titles of courses in the Comp. Sci. department that have 3 credits. Find the names of all students who have taken at least...

Q:

Problem 3 . 1 1 Write the following queries in SQL , using the university schema. Find the ID and name of each student who has taken at least one Comp. Sci. course; make sure there are no duplicate...

Q:

An electric field of strength E = 1.0 kV/cm produces polarization in water equivalent to the correct orientation of only one out of N molecules. Find N. The electric moment of a water molecule equals...

Q:

In the context of marketing research, what is the relationship between each of the following sets of terms? a) Research objectives and hypotheses b) Observation and experimental research c)...

Q:

62. Anew automated production process averages 1.5 breakdowns per day. Because of the cost associated with a breakdown, management is concerned about the possibility of having three or more...

Q:

What is your definition of leisure? Why would 12 percent of the American workforce never take vacations?

Q:

Give an SQL schema definition for the employee database of Figure. Choose an appropriate domain for each attribute and an appropriate primary key for each relationschema. employee (employee-name,...

Q:

Write check conditions for the schema you defined in Exercise 4.14 to ensure that: a. Every employee works for a company located in the same city as the city in which the employee lives. b. No...

Q:

Describe the circumstances in which you would choose to use embedded SQL rather than SQL alone or only a general-purpose programming language.

Q:

Ross and Rachel are married and have two children. They are covered by a comprehensive medical and major medical policy with a $ 2 0 0 embedded deductible per person, an 8 0 / 2 0 coinsurance...

Q:

Worth 1 Point Question 1: Self-Test 3-1 (algorithmic) Question Help Lever Inc. owed its bank 57 million at the start of the year. The bank charges interest at 6.8%. How large is Lever Inc.'s interest...

Q:

april put october put Use the option quote information shown here to answer the questions that follow. The stock is currently selling for $83. Are the call options in the money? What is the intrinsic...