Question: 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

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 those departments and the average salary for each department.

10. For those departments which have average salary greater than $50,000, show the department number (dno), the number of employees working for those departments and the average salary for the respective department.

11. Show all information about those employees who have dependents. ( no duplicate rows duplicate rows will get 0 points !)

12. Show each employee's first name, last name and his/her manager's first name and last name.

APPENDIX

Consider the Database in Appendix (you can tear off the Appendix page

DEPENIDANT \begin{tabular}{ccccc} ESSN & DEPENDENT NAME & SEX & BDATE & RELATIONSHIP \\ \cline { 2 - 5 } 333445555 & Alice & F & 4/5/1986 & Daughter \\ 333445555 & Theodore & M & 10/25/1983 & Son \\ 333445555 & Joy & F & 5/3/1958 & Spouse \\ 987654321 & Abner & M & 2/28/1942 & Spouse \\ 123456789 & Michael & M & 1/4/1988 & Son \\ 123456789 & Alice & F & 2/12/1988 & Daughter \\ 123456789 & Elizabeth & F & 6/5/1967 & Spouse \end{tabular} EMPLOYEE DEPARTMENT

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!

Consider the Database in Appendix (you can tear off the Appendix page for easier viewing) and write the following SQL queries 10. For those departments which have average salary greater than $50,000,...

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

Consider the Database in Appendix (you can tear off the Appendix page for easier viewing) and write the following SQL queries 13. For those employees who work for department number 5, show employee's...

Consider the Database in Appendix (you can tear off the Appendix page for easier viewing) and write the following SQL queries 3. Show the entire information about all departments and the name of the...

Consider the Database in Appendix (you can tear off the Appendix page for easier viewing) and write the following SQL queries 12. Show each employee's first name, last name and his/her manager's...

Consider the Database in Appendix (you can tear off the Appendix page for easier viewing) and write the following SQL queries 11. Show all information about those employees who have dependents. ( no...

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

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

Business law Note 1, we assume 1K = 1000, IM = 1,090,000, 1G = 1,000,000,000, 1Byte = 8 bits Note 2, Is = 1,000 ms = 1,000,000us 1. (20 points) We are sending a MP3 file of 1,000,000 bits from a...

For? success, a solution must be A. exciting. B. feasible. C. appealing. D. well documented.

The sales department of C. Mack Manufacturing Co. has forecast sales for its single product to be 20,000 units for June, with three-quarters of the sales expected in the East region and one fourth in...

the tactical plans of an entity need to be translated into budgets for a business entity to be successful in the long - term true or false?

8:37 * N. 80% i ... OBJECTIVES: Create relationships Create a Pivot Table from Related Tables Create a PivotChart Modify the PivotChart The major section in this chapter :ontinuation is: Data...

Analyze returned sales to find explanatory (independent) variables using descriptive and exploratory analytics.

Illustrate hypothesis testing using diagnostic analytics to compare and contrast sales returns around the holiday season.

While you still have your auditor hat on, what are some additional analyses you could perform to understand whether the purchase process is being followed or controls are functioning properly?