Question: SQL: a) Retrieve the names of all employees whose supervisor has 888665555 for SSN. b) Retrieve the names of all employees who work in the

SQL:

a) Retrieve the names of all employees whose supervisor has 888665555 for SSN.

b) Retrieve the names of all employees who work in the department that has the employee with the highest salary among all employees.

c) Find the SSNs of department managers who dont have dependents.

Thank you in advance!

SQL: a) Retrieve the names of all employees whose supervisor has 888665555 for SSN. b) Retrieve the names of all employees who work in

EMPLOYEE Frame Minit Lname ssn Bdate Address Sex Salary Super-ssn Dino John B Smith 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 333445555 5 Franklin T Wong 333445555 1955-12-08 638 Voss, Houston, TX LM 40000 888665555 5 Alicia J Zelaya 999887777 1968.01-19 3321 Castle, Spring, TX F 25000 987654321 4 Jennifer S Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX F 43000 B88665555 4 Ramesh K Narayan 666884444 1962.09.15 975 Fire Oak, Humble, TX M 38000 333445555 5 Joyce A English 453453453 1972-07-31 5631 Rice, Houston, TX F 25000 333445555 5 Ahmad v Jabbar 987987987 1969-03-29 980 Dallas, Houston, Tx M 25000 987654321 4 James E Borg 888665555 1937. 11.10 450 Stone, Houston, TX M 55000 NULL 1 DEPARTMENT DEPT LOCATIONS Dname Dnumber Mgr ssn Dnumber Dlocation Mgr start date 1 5 333445555 1988-05-22 Research Houston 4 4 Stafford 987654321 1995-01-01 Administration 1 5 888665555 1981-06-19 Bellaire Headquarters 5 Sugarland 5 Houston

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!

Use the company database to complete the following tasks. Write a query that shows the number of projects per person Write a query that shows the average salary by the department. Write a query that...

Answer the following query in SQL. a. Retrieve the names of all employees who work in the department that has the employee with the highest salary among all employees. b. Retrieve the names of all...

Retrieve the names of all employees whose supervisors SSN is 888665555. For each department manager, retrieve his/her name along with the names of projects that he/she is working on. Retrieve the...

SQL 1. Retrieve the names of all employees whose department manager's SSN is 888665555. 2. Retrieve the name of the employee who has Alice as a dependent. 3. For each department manager, retrieve...

69 SQL Assignment 4 Retrieve the names of all employees whose supervisors SSN is 888665555. For each department manager, retrieve his/her name along with the names of projects that he/she is working...

/* company.sql Script to define and populate the example database COMPANY from Chapter 3 of Elmasri and Navathe (pp.70-75 in the 6th edition), with some modifications */ -- drop tables DROP TABLE...

For the Pizza Delivery Shop DB, (see Appendix), write SQL queries to answer each of the following questions. a) List all the last names, phone numbers and zip codes of the customers. b) List...

drop table EMPLOYEE; drop table DEPARTMENT; drop table DEPT_LOCATIONS; drop table PROJECT; drop table DEPENDENT; drop table WORKS_ON; CREATE TABLE EMPLOYEE (Fname VARCHAR(15) NOT NULL, Minit CHAR,...

2. For the Company Projects DB, (see Appendix), write SQL queries to answer perform each of the following actions. a) For each department whose average employee salary is more than $30,000, retrieve...

HELP IN F,G,H,I,J THANK YOU IN ADVANCE EMPLOYEE Fname Minit Lname Ssn Bdate Address Sex Salary Super_ssn Dno DEPARTMENT Dname Dnumber Mgr_ssn Mgr_start_date DEPT_LOCATIONS Dnumber Plecation PROJECT...

[20 marks] Below figure shows a part of the production line of carrot milk in the F&B company. Initially, the production begins with the blending of carrot, water, and condensed milk to form the raw...

Prove parts (b) and (c) of Theorem 16.5. f(an) = [f(a)n for all a G and all n Z.

The semi - annual, 7 - year bonds of Kia , Inc. are selling at par and have an annual yield of 6 . 6 0 % . What is the amount of each interest payment on a $ 1 , 3 0 0 Kia bond?

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

LO5 Highlight five external recruiting sources.

LO6 Define recruiting measurement and metrics and illustrate how analytics can be used to improve talent acquisition.

1. The mass retirement of Baby Boomers and the smaller generation that follows puts candidates in the drivers seat. Organizations will need to woo prospective employees and manage the candidate...