Question: I have a schema I want these SQL queries 1. Find the top 4 instructors whose courses have the maximum enrollment in all of their

I have a schema

I have a schema I want these SQL queries 1. Find the

I want these SQL queries

1. Find the top 4 instructors whose courses have the maximum enrollment in all of their courses combined.

Output columns: InstructorName, TotalEnrollment

Sort by: TotalEnrollment in descending order

2. List all the courses offered by the departments Comp. Sci. and History. Output should not contain any duplicates.

Output columns: DepartmentName, CourseID

Sort by: CourseID in ascending order.

3. List all the courses that have prerequisites offered by a different department.

Output columns: Course_id, Course_department, Prereq_id, Prereq_department

Sort by: Course_id in ascending order

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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 Databases Questions!

Q:

I have a schema like eg I want these SQL queries 1. Find the top 4 instructors whose courses have the maximum enrollment in all of their courses combined. Output columns: InstructorName,...

Q:

Write SQL queries for questions f-j using the following University schema Classroom(building, room number capacity) Department(dept name, building, budget) Course(course id, title, deptname, credits)...

Q:

Objective: Design and implement a University Management System ( UMS ) that manages information about students, courses, instructors, departments, and enrollment records. Your goal is to design the...

Q:

1 Find the names of courses in Comm.Sci.department which have 3 credits. 2 For the student with ID 1 1 4 5 5 . show all course _ ( i ) d and title of all courses registered for by the student. 3 Find...

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:

I have a schema that looks like this These are the SQL queries I need 1. Find the names of the top 4 instructors who have taught the most number of distinct courses. Display also the total number of...

Q:

Part 2 : Database Creation and SQL Queries ( 9 0 marks ) In this part of the assignment, you will create a database and perform a series of tasks to test your understanding of SQL . Each task has...

Q:

I want to perfect answer for the question 1 to 17 Using the university database, give the following queries in SQL (SQL Server 2019). 1. Find the ID and name of each student who did not take any...

Q:

SQL server 2012 Products databse column names associated with this:SELECT TOP 1000 [ProductID] ,[ProductName] ,[SupplierID] ,[CategoryID] ,[QuantityPerUnit] ,[UnitPrice] ,[UnitsInStock]...

Q:

This assignment uses an actual PostgreSQL database with data about a university. The schema of the database is provided below. Keys are in bold face and underlined, field types are omitted; assume...

Q:

Although the multi-stage compression with intercooling improves the volumetric efficiency, it increases leakage loss. * O False O True

Q:

Read the following passage and give answers: Five Native Americans sought to cancel six Pro-Football, Inc. registered trademarks, including the marks "The Redskins," "Washington Redskins," and...

Q:

Sold Corp. currently offers annual dividends of $ 3 . 3 is expected to offer $ 2 . 3 per year dividends over the next year and $ 3 . 6 8 per year and dividends the year after that at the end of the...

Q:

QUESTION 3 An insurance contract has a straight deductible worth 100BD. additionally it also has a coinsurance agreement which specifies that a 66% coinsurance clause exists on a car valued at 23,402...

Q:

Write formal and informal proposals.

Q:

Describe the components of a formal report.

Q:

Write formal and informal reports.