Question: 16. Repeat Question #15, but this time use the EXISTS operator in your formulation. 17. Find the employee SSN, and employees first and last name,

16. Repeat Question #15, but this time use the EXISTS operator in your formulation.

17. Find the employee SSN, and employees first and last name, and salary for each employee whose salary is more than $40,000 or who is in project number 1. Use UNION set operator.

18. List the employee SSN, employees first and last name, his/her dependent name, and relationship. Be sure all employees are included in the result, regardless of whether he/she has any dependents or not. You have to use outer join.

19.List the department name, employee SSN, and employees first and last name, and salary of each employee who is in production department and his/her salary is at least $35,000.

20. List employee SSN, and employees first and last name, and salary, who are in project number 30.

16. Repeat Question #15, but this time use the EXISTS operator in your formulation. 17. Find the employee SSN, and employees first and last

t No Name Headquarters Admin and Records 999555555 Production Start Date 999666666 2005-06-19 2013-01-0 1998-05-22 999444444 Employee EMP SSN FName Name Address City DOB | Salary | Park- | Gender | Dep | Super-SSN t No Space 99 BockDouglas Verd 1955 30000 542 St. Louis MO 6312 7 999444444 3 999555555 7 1999444444 7999666666 999222222Amin Hyder Seaside Marina CA 93941 03-29 25000 422 M 999333333 Joshi Dinesh Oak St Consville IL 66234 38000 332 M 1975 43000 32 999444444 Zhu Waiman Lindber St. Louis MO 63121 555555 JoynerSuzanneBurns Marina CA93941 3 999666666 South |Edwardsvill | IL |62025|i1-10 967 55000 999666666 Bordoloi Bijoy Main High St. Monterey 1978 9394007-19 999887777 Markis Marcia CA9 25000 402 F 999555555 Overton Edwardsvill | Way #4 | e 999888888 Prescott Sherni 62025 07-31 25000 296 F 7 999444444 Number Work Hours

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!

Please answer the SQL questions according to the information below thanks Use the operator and/or statement asked. Otherwise, you will have zero (0) point for the question. Your answer document MUST...

Submission: Your answer document MUST show SQL statement for each question (No query results required). Copy and paste SQL statements Microsoft Word or PDF file and submit the Word or PDF file Put...

Please answer the SQL questions 11-20 according to the information below thanks Use the operator and/or statement asked. Otherwise, you will have zero (0) point for the question. Your answer document...

CUSTOMER table INVOICES table INVOICE_LINE table ITEM table SALES_REP table Task 5: Repeat Task 4 , but this time use the EXISTS operator in your answer. Task 6: Find the ID, first name, and last...

1. List the employee SSN, first and last name, birth date, and salary of each employee. 2. For each project, list the project name and its average hours worked, but consider only those projects for...

Assignment 1 ( 6 % ) Instruction: All the questions are based on HR database. Submit screenshot for each question that shows the code and the output. Q 1 . Write a query in SQL to display first, last...

1. Create a new database companyx, all the existing the relations implied from tables shown and populate it. 2. From the Wamp, export the PDF that shows all tables and their relations. 4 4 EMPLOYEE...

For the Part IV (Week 7) assignment, you are asked to do the following: Use the Parts I, II, and III assignments you completed previously. Correct your Part III assignment mistakes, if any, based on...

Need C++ Help on program. My code posted below. Use of vectors not allowed. Please compile code first. Rating best solution thumbs up! :) Directions: Note: We are encouraged to use substr, find,...

Chapter 8 Homework Answer the questions below. In doing this homework, you dont have to use a DBMS. If you didnt create MSU Corporation datanase to do Chapter 7 homework, you can use the table...

In preparation for its tire rotation, a car weighing 2.25 tons is placed on a hydraulic garage lift. The mechanic then raises the car 30.0 cm. (a) Calculate the work done on the car when it is...

Describe the role of culture within the Save the Children organization. How does this culture impact the hiring process at Save the Children?

The definition for a new patient states that the patient is one who has not received professional services from the physician or another physician of the same specialty who belongs to the same group...

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

KEY QUESTION Use the aggregate demandaggregate supply model to compare the old classical and the Keynesian interpretations of ( a ) the aggregate supply curve and ( b ) the stability of the aggregate...

KEY QUESTION Between 1990 and 2005 the U.S. price level rose by about 50 percent while real output increased by about 56 percent. Use the aggregate demandaggregate supply model to illustrate these...

Productivity often rises during economic expansions and falls during economic recessions. Can you think of reasons why? Briefly explain. (Hint: Remember that the level of productivity involves both...