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

I need help with this query 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. On average what percentage of students fail a course? (total number of students that failed a course / total number of enrolled students). A student failed the course if he/she gets a 'D' or an 'F'.

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!

need help with this query 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...

In this practice exercise you will play with SQLite. First go through SQLite Tutorial (http://www.tutorialspoint.com/sqlite/ You can use any other SQLite tutorial) and see/learn basic SQLIte commands...

I need help with these 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...

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...

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

CREATE TABLE students( sid char(10), name varchar, age int, gpa float, PRIMARY KEY(sid)); CREATE TABLE courses( cid varchar(7), deptid varchar(10), name varchar(20), PRIMARY KEY(cid)); CREATE TABLE...

Answer required in SQL (Need 8-14) Given the following tables: . students(sid,name,age,gpa) courses(cid,deptid, name) professors(ssn,name,address,phone,deptid) enrollment(sid,cid,section,grade,...

Given the following tables: students(sid name,age,gpa) . courses(cid,deptid, name) . professors(ssn,name,address,phone,deptid) section.grade enrollment (sid.cid foreign key (sid) references students,...

Given the following tables: students (sid,name,age,gpa) courses (cid,deptid, name) professors (ssn,name,address,phone,deptid) enrollment (sid,cid,section,grade, foreign key (sid) references students,...

Create a database in MySQL using the attached mysqluniversity.sql file. Use the command: mysql - u username - p mysqluniversity.sql , where username may be root or other user that you have configured...

Find the flux of the Earths magnetic field of magnitude 5.00 x 105 T through a square loop of area 20.0 cm2 (a) When the field is perpendicular to the plane of the loop, (b) When the field makes a...

Prove the following result in three ways (as in Theorem 2.4): If n is an odd integer, then n + 11 is even.

10 Did the investigations on Mars show that the gas definitely did not come from living things? Explain your answer.

please help me solve 2&3 1. (1 point) what is the capital ratio of the High capital bank and the Low capital bank respectively? 2. (1 point) If both banks suffer a bad loan loss of $5 million, how do...

KEY QUESTION The income elasticities of demand for movies, dental services, and clothing have been estimated to be 3.4, 1, and .5, respectively. Interpret these coefficients. What does it mean if an...

ADVANCED ANALYSIS Let MU A z 10 x and MU B z 21 2 y , where z is marginal utility per dollar measured in utils, x is the amount spent on product A, and y is the amount spent on product B....

KEY QUESTION Complete the following table and answer the questions below: Units Consumed Total Utility Marginal Utility 0 0 1 10 10 2 8 3 25 4 30 5 3 6 34 a. At which rate is total utility...