Question: Write the following SQL query: List the fname, lname for employees who have more than the average number of dependents. Compute the average number of

Write the following SQL query: List the fname, lname for employees who have more than the average number of dependents. Compute the average number of dependents over ALL employees, not just those with dependents.

The database is as follows:

Write the following SQL query: List the fname, lname for employees who

EMPLOYEE | FNAME | MINIT |LNAME | SSN SEX SALARY | SUPERSSN DNO Smith 123456789 1965-01-09 333445555 638 Voss, Houston, TX 987654321 Wallace 9876543211941-06-20 975 Fire Oak, Humble, TX 5631 Rice, Houston, TX 980 Dallas, Houston, TX 450 Stone, Houston, TX Narayan 453453453 1972-07-31 987987987 1969-03-29 333445555 Jabbar 987654321 Borg DEPT LOCATIONS DNAME Research DNUMBER MGRSSN MGRSTARTDATE 1988-05-22 995-01-01 1981-06-19 DEPARTMENT Headquarters WORKS ON ESSNPNO HOURS 123456789 53453453 PROJECT PNAME PNUMBER PLOCATION DNUM 987987987 987987987 ESSN I DEPENDENT NAME SEX BDATE RELATIONSHIP Theodore 1983-10-25 1958-05-03 1942-02-28 1988-01-04 SPOUSE EMPLOYEE | FNAME | MINIT |LNAME | SSN SEX SALARY | SUPERSSN DNO Smith 123456789 1965-01-09 333445555 638 Voss, Houston, TX 987654321 Wallace 9876543211941-06-20 975 Fire Oak, Humble, TX 5631 Rice, Houston, TX 980 Dallas, Houston, TX 450 Stone, Houston, TX Narayan 453453453 1972-07-31 987987987 1969-03-29 333445555 Jabbar 987654321 Borg DEPT LOCATIONS DNAME Research DNUMBER MGRSSN MGRSTARTDATE 1988-05-22 995-01-01 1981-06-19 DEPARTMENT Headquarters WORKS ON ESSNPNO HOURS 123456789 53453453 PROJECT PNAME PNUMBER PLOCATION DNUM 987987987 987987987 ESSN I DEPENDENT NAME SEX BDATE RELATIONSHIP Theodore 1983-10-25 1958-05-03 1942-02-28 1988-01-04 SPOUSE

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!

2.Using the company.sql database (posted down), write the following SQL queries. 1.Find the names of all employees who are directly supervised by 'Franklin T Wong' 2. For each project, list the...

database For this assignment, you will use your SQL Server. As an alternative to SQL Server, you are allowed to use a different database, e.g. MySQL, Postgres, or SQL Server installed in your own...

Consider the Database in Appendix and write the following SQL queries. Show the entire information about the employees (all rows and columns of the employee table). Show the entire information about...

Consider the Database in Appendix and write the following SQL queries. 1. For those departments which have average salary greater than $50,000, show the department number (dno), the number of...

1.Write one SQL statement to set up table MoSpo HallOfFame according to the following Relational Schema: MoSpo HallOfFame(hoFdriverId, hoFYear, hoFSeries, hoFImage, hoFWins, hoFBestRaceName,...

You will need to write SQL queries over the database schema created by the commands below. CREATE TABLE Company (cname varchar(30) primary key, country varchar(30)); CREATE TABLE Product (pname...

Consider the above given schema and write down following SQL queries. 1. Display the highest, lowest, sum and average salary of all employees. Label the columns Maximum, Minimum, Sum and Average...

Consider the Database in Appendix and write the following SQL queries. 1. Show the first name and the last name of those employees who make more than the average salary of all employees. 2. Show the...

Specify the following SQL queries on the Company database as discussed in class 1 . Retrieve the average salary of all employees who works on ProductX project 2 . For each employee with dependents,...

Consider the Database in Appendix (you can tear off the Appendix page for easier viewing) and write the following SQL queries 9. Show the department number (dno), the number of employees working for...

What is 2 phase motor?

Students of the author collected data measuring the accuracy of wristwatches. The times (sec) below show the discrepancy between the real time and the time indicated on the wristwatch. Negative...

Costs that pertain to finding a trading oartner and making a trade are called

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

=+foreign language(s)? Who should take responsibility (headquarters personnel, host-country specialists, or third-party vendors) for translation? Should

=+e-learning in the MNE? Can training programs be developed in various locations and made available to everyone? What are the effects of the various options?

=+training programs be exported from headquarters or should overseas employees be brought to centralized or regional training facilities? How effective is