1. Engineering
  2. Computer Science
  3. using the university schema write a sql query that returns...

Question: using the university schema write a sql query that returns...

Question details

Using the University schema, write a SQL query that returns the Title of courses (could be from any department) where at least one 'CS' student scored the highest. Note that, more than one student can receive the highest score.

The Students, Enrollments, and Courses table are defined as follows Students Column Name Netld FirstName LastName Type VARCHAR(10) VARCHAR(255) VARCHAR(255) Department VARCHAR(100) Enrollments Column Name Netld CRN Credits Type VARCHAR(10) INT INT REAL Score Courses Column Name Type CRN Title Department VARCHAR(100) Instructor INT VARCHAR(255) VARCHAR(255)

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution