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

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

Retrieve the managers first and last name of the each department that locates in Houston.

Find the SSNs of department managers who dont have dependents.

(Extra credit)Retrieve the first and last name of each department manager and the first and last name of his/her immediate supervisor.

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!

Q:

Daniel B. Butler and Freida C. Butler, husband and wife, file a joint return. The Butlers live at 625 Oak Street in Corbin, KY 40701. Dan's Social Security number is 111-11-1112, and Freida's is...

Q:

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

Q:

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

Q:

For the COMPANY database, write the proper SQL Statements to answer the following queries using MySQL DBMS. To install MySQL Server in your own environment, please see Web links posted on Course Web...

Q:

My tables create table s_employee( e_ssn number(9), super_ssn number(9), dept_num number(4) not null, firstname varchar2(30) not null, lastname varchar2(30) not null, middleint varchar2(1), street...

Q:

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

Q:

Consider the schema below and specify the queries using relational algebra. Please submit the answers in PDF or Word to Canvas. EMPLOYEE Fname Lname SSN BirthDate Sex Salary SuperSSN DNo DEPARTMENT |...

Q:

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

Q:

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

Q:

Using the tables below: Provide the SQL statements to: 1) Retrieve the names of all employees in department 5 who work more than 10 hours per week on the ProductX project. 2) List name of each...

Q:

EMPLOYEE FNAME MINIT John Franklin Alicia Alicia Jennifer Ramesh DEPARTMENT WORKS ON Joyce Ahmad James DEPENDENT ESSN 123456789 123456789 666884444 453453453 453453453 453453453 433430490 333445555...

Q:

Florida Company purchased a building and the land on which the building is situated for a total cost of $800,000 cash. The land was appraised at $300,000 and the building at $700,000. Required a....

Q:

3. show that the thermal efficiency of the Carnot cycle in terms of the isentropic compression ratio is given by e 1-

Q:

2.96 Police plan to enforce speed limits by using radar traps at four different locations within the city limits. The radar traps at each of the locations L1 , L2 , L3 , and L4 will be operated 40%,...

Q:

CT Corp Comprehensive Question Canadian Tire Corporation, Limited ( Canadian Tire ) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

Q:

Based on the material presented here and other publically available information, were the strategic choices exercised by Baba Ramdev in framing the Patanjali narrative effective?

Q:

Considering the previous question: It is always easy to judge HR limitations from the outside. What are the meanings of diversity in your country of origin or societal and national contexts you are...

Q:

Why could the Robert Bosch approach make sense to the company?