Reference no: EM132078924
You 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
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'.
|
Find out and show the percentage of instances
: Choose two factor variables. For each factor variable, show a barplot of the number of instances (or count) with a nominal value for each possible value.
|
|
Cell-surface receptors and intracellular receptors
: Both cell-surface receptors and intracellular receptors can be involved in pathways that lead to changes in gene expression.
|
|
Compute the payback period
: West Hill Hardware is adding a new product line that will require an investment of $1,500,000. Compute the payback period
|
|
Sickle-cell anemia is an example of co-dominance
: In humans, sickle-cell anemia is an example of co-dominance, when considered at the molecular level.
|
|
On average what percentage of students fail a course
: On average what percentage of students fail a course? A student failed the course if he/she gets a 'D' or an 'F'.
|
|
Prepare the direct materials usage and purchases budget
: The Radco Company produces and sells pumpkin-sized Halloween product. Prepare the Direct Materials Usage and Purchases Budget
|
|
How does artificial selection and genetic engineering
: How does artificial selection and genetic engineering both result in humans impacting the environment in other ways (pesticide use, transportation, etc)
|
|
What is the accounting equation
: What is the accounting equation? What are the four basic financial statements? Describe the statement of cash flows, and explain why it is important
|
|
Resulting two parts of chromosome
: Before cell division of somatic cells, each chromosome must be replicated. After replication, the resulting two parts of each chromosome are held together
|