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

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 manager who manages these departments.

4. Show the first and last name of those employees who make more than 40,000

5. Show the entire information about the employees but sorted in an order such as highest paid employee is in the first row and lowest in the last

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 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 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 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 11. Show all information about those employees who have dependents. ( no...

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

Assessment 2: Authentic tasks - Organisational Analysis Report and Group Presentation Group members: Students names and numbers: Name and Number Name and Number Name and Number Name and Number...

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

A $2,900 loan at 7.4% was repaid by two equal payments made 30 days and 60 days after the date of the loan. Determine the amount of each payment. Use the loan date as the focal date.

Indicate whether the following sentences are true or false. 1.The cinema, in addition to entertaining, serves to transmit values and ideologies. 2. Analyzing a film consists of telling its plot. 3....

From a book, choose a painting that everyone on your team likes. Brainstorm a list of words or phrases that describe the painting, its mood, and the teams feeling toward the painting. Then use those...

Questions Q1. Write a Python program to retrieve the first and last colors from the following list: color_list = ["red", "green", "white", "blue", "black") Q2. Given the following dictionary,...