Question: 4. Create the following table to compose the SQL queries below. The tables only show a subset of the data hence, your SQL querics answers

4. Create the following table to compose the SQL queries below.

4. Create the following table to compose the SQL queries below. The tables only show a subset of the data hence, your SQL querics answers should assume the tables contain more data rows. ENROLLMENT ENROLLMENT enrollment id|course name |age 20 30 40 50 60 70 CINS 101 CINS 201 CINS 101 CINS 101 CINS 201 CINS 301 34 30 18 student status active eave leave active robatiorn active 34 a. Show the complete SQL query that uses the aggregate function which displays a summarized average age amount grouped by course name, ofonly the students having a student status of "leave". In other words, for cach course name display the course name with its average student age b. Add only the additional SQL line of code need to further filter the summarized data such that courses with a class average age of 25 or more are removed from the output. Show the full command along with its output Show the SQL query that uses an aggregate function to display the number of rows table ENROLLMENT contains. The query c. should NOT display the values from all the rows. 4. Create the following table to compose the SQL queries below. The tables only show a subset of the data hence, your SQL querics answers should assume the tables contain more data rows. ENROLLMENT ENROLLMENT enrollment id|course name |age 20 30 40 50 60 70 CINS 101 CINS 201 CINS 101 CINS 101 CINS 201 CINS 301 34 30 18 student status active eave leave active robatiorn active 34 a. Show the complete SQL query that uses the aggregate function which displays a summarized average age amount grouped by course name, ofonly the students having a student status of "leave". In other words, for cach course name display the course name with its average student age b. Add only the additional SQL line of code need to further filter the summarized data such that courses with a class average age of 25 or more are removed from the output. Show the full command along with its output Show the SQL query that uses an aggregate function to display the number of rows table ENROLLMENT contains. The query c. should NOT display the values from all the rows

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!

3. Create the following tables to write the SQL queries below. The tables only show a subset of the data hence, your SQL queries answers should assume the tables contain more data rows. When...

In this assignment, we will create an application which runs on the sample database from the Forta textbook. We will code it in the spirit of three-tier architecture. You will set up the data tier...

Perform all the following steps in order. ***WRITE SQL QUERIES TO: ---STEPS ALREADY COMPLETED--- 1. Create a junction table with artist_id and rec_id as fields. Call this new table rec_artist. Create...

Perform all the following steps in order. ***WRITE SQL QUERIES TO: 1. Create a junction table with artist_id and rec_id as fields. Call this new table rec_artist. Create a foreign key constraint for...

Lab Exercise 2: C\# .NET 6 Class Library For exercises 24, create a blogging site using ASP.NET Web API and SQL Server Database. The site must have log in, registration, and post functionality...

Perform all the following steps in order. ***WRITE SQL QUERIES TO: 4. Do the following as a transaction: Delete the column artist_id from the recordings table. Show the structure of the recordings...

Consider the following subset of relations from the RVH database: Patients ( pid , name, address, telephone, care _ centre _ id ) Care _ centres ( cid , name, location, nurse _ charge _ id )...

Jonathan's Magic Emporium was founded in 1957 in Seattle, Washington. It has grown into an internationally recognized organization in the magical community. The company is in two buildings. One...

Consider the following set of requirements for a UNIVERSITY database that is used to keep track of students' transcripts. (a) The university keeps track of each student's name (first name and last...

SQL Query Design Module Preview This guide contains a preview of the materials for all module courses in this series: Using a Relational Database Management System Single Table Query Commands...

Suppose a company has 1110 warehouse workers. The company administers a polygraph test that is 87% accurate. Of the 1110 workers, 20 actually lie during the polygraph test. Answer the following...

What are the guidelines that accountants use to decide whether an investment should be classified as a current asset?

What are the rules concerning reporting periods for tax purposes? A a business must file tax returns reporting income inductions on a quarterly basis B business must report their income and...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Question How is life insurance used to finance an employers obligation under a nonqualified deferred compensation plan?

Question How is an age-weighted formula applied when shareholder-employees of an S corporation are covered?

Question Can I collect benefits if I become disabled?