Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help with this two quieries in sql. here are the tables students(sid,name,age,gpa) // sid is the primary key courses(cid,deptid, description) // cid,deptid is

I need help with this two quieries in sql.

here are the tables

students(sid,name,age,gpa) // sid is the primary key

courses(cid,deptid, description) // cid,deptid is the primary key

professors(ssn,name,address,phone,deptid) // ssn is the primary key

enrollment(sid,cid,section,grade) cid makes reference to the courses table. // sid, cid, and section is the primary key

teaches(cid,section,ssn). cid, section makes reference to the enrollment table // cid, section is the primary key

a. List of professors that work for departments with more than 20 faculty members and that offer more large sections than small and medium sections combined. Assume that small sections have less than 30 students, medium sections have at least 30 students but less than 80, and large sections have at least 80 students.

b. Find a list of courses (sections) where the percentage of students with D or F is greater than average.

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

Securing SQL Server Protecting Your Database From Attackers

Authors: Denny Cherry

3rd Edition

0128012757, 978-0128012758

More Books

Students also viewed these Databases questions

Question

How will the members be held accountable?

Answered: 1 week ago

Question

a. How will the leader be selected?

Answered: 1 week ago