Question: write the following queris in sql : a) Using nested query , retreive the sependent names of male employees whose salary > 30000 b )

write the following queris in sql :

a) Using nested query , retreive the sependent names of male employees whose salary > 30000

b ) list the female employee, who are not managers

write the following queris in sql : a) Using nested query ,

EMPLOYEE Fname MinitLname John Franklin T Wong 333445555 1955-12-08 638 Voss, Houston, TX M 4 Ssn Sex Salary Super sen Dno B Smith 123456789 1965 01-09 731 Fondren, Houston, TX M 30000 13334455 AliciaZelaya 999987777 1968-01-19 3321 Castle, Spring, TXF Jennifer S Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX Ramesh K Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M 380 Joyce A Engish 453453453 1972-07-31 5631 Rice, Houston, TXF 25000 Ahmad Jabbar 9879879871969-03-29 980 Dallas, Houston, TX M 25000 Jamcs EBorg 888665555 1937-11-10 450 Stone, Houston, TX M55000 4300 65555 4 38000 333445555 987654321 4 DEPARTMENT DEPT LOCATIONS Mgr.ssn 333445555 987654321 888665555 Mgr start date 1988-05-22 1995-01-01 5 5 WORKS ON PROJECT Pno Hours 132.5 7.5 3 40.0 Pnumber PlocalionDnum Bellaire 2 Sugarland 5 Pname 123456789 123456789 ProductY 68684444 3 0.0 462453453 453453453 333445555 333445555 3 333445555 333445555 2010.0 999887777 30 30.0 20.0- Computurication40 Stafford Reorganization 20 Houston Newbenefits 2 20.0 2 10.0 30 Stafford 310.0 10 10.0DEPENDENT Esan Dependent aa SesBdatoRohiterati' 333445555 Alice 333445555 Theodone 333445555 Joy F 1986-04-05 Daughter M 1983-10-25 Son F1958-05-03 Spouse M 194202-28 Spouse 99987772 10 10.0 10 35.0 987987987 98798798730 987654321 987654321 888665555 987854321 Abner .| M | 1988-01-04 | Son 30 20.0 20 15.0 20 NULL 123456789 Michael 123456789 Alice 123456789 Elizabeth F 1988-12-30Daughter F 1967-05-05 Spouse Scanned by CamScanner

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!

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

2.Using the company.sql database (posted down), write the following SQL queries. 1.Find the names of all employees who are directly supervised by 'Franklin T Wong' 2. For each project, list the...

I need help with my assignment I am supposed to use command prompt and sequel for it There are three tasks in this assignment: A) create tables , B) insert data , and C) c omplete queries. For each...

Chapter 4 1. Write a query that will select all columns from the projectAssignment table without using the (*) in your query. You may wish to use the DESCRIBE command to examine the structure of the...

Write a SQL query to find the employees who work as FI _ ACCOUNT or ST _ CLERK, are in Southlake, Texas or Seattle, Washington, have more than 5 years of experience, and do not receive a commission....

I don't know how to create the tables in command prompt for the sql server. This assignment counts as one lab in the LAB category of your grade & is worth 100 points. This is an INDIVIDUAL,...

Help me solve this using SQL Manufacturing Company The company has offices in three cities: Boston, New York, and Cleveland. The database has to support data about departments and employees of the...

Leher C o COMPANY d The SOL SOLM can be dow b oard wideo with the references. You need to modify the m leasumber of changes to the schema get you Again, the 2. A creating the pa th COMPANY SQL int...

2. Write an SQL Query that will produce a list of Employees first name, and their Department Names. Show the SQL below: 3. Write an SQL Query that will produce a list of Employees first name, and...

1. Create the tables for the COMPANY database in Oracle SQL. Make sure that all the constraints are enforced. The SQL statements can be downloaded from the Blackboard link company_create.htm. The...

Refer to the information for Quillen Company above. Quillen Company manufactures a product in a factory that has two producing departments, Cutting and Sewing, and two support departments, S1 and S2....

Defend or contradict the choice to use the following materials as hot-melt adhesives for an application in which the assembled part is subjected to impact loading: (a) Polyethylene; (b) Polystyrene;...

Let s assume that marginal taxpayer ( who set the price ) is receiving dividends. Share price before the stock goes ex - dividend is 1 0 1 and dividend per stock is 5 . The tax rate for dividends is...

We synthisezd a new material in the lab, please design the experiments to measure ( a ) surface area; ( b ) if we measure the adsorption equlibrium conatansts for O 2 K 0 2 = 2 0 , and K N 2 = 5 ,...

What are the Variable columns settings available in the Mining Models Tab?

What does the Mining Content Viewer in Visual Studio show in terms of Probabilities?

How are continuous variables normally handled in Decision Tree Algorithms?