Question: need help Use sub queries to answer the following 01) write a query to display the employees first name and department id for all employees

need help

Use sub queries to answer the following 01) write a query to display the employees first name and department id for all employees who work in sales department. 1 pts I 02) write a query to find the employee who earns a salary greater than the average salaries for department 50.1 pts 03) display the department names and ids that is located in the country United States of America". 1pts 04) display the names and salaries of employees who get a salary greater than the average between max salary and min salary for his job. 2pts

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 sub queries to answer the following Q1) write a query to display the employees first name and department id for all employees who work in sales department. 1 pts Q2) write a query to find the...

QUESTION 5 Consider the following relational schema for a company: country(countryID, countryName, RegionID) employee(employeeID, firstName, lastName, email, phoneNo, hireDate, salary, jobID,...

Write SQL queries to answer the following: (a) Write a query to display the full name and hire date for all employees who were hired in the year 2012. (b) (c) (5 marks) Write a query to get the...

QUESTION 5 Consider the following relational schema for a company: country ( ceuntrolD , countrxName, RegionlD ) employee ( emplexeeID , firstName, lastName, email, phoneNe, hireDate, salary, iobID,...

Looking for 5.1-5.10 5. Create Queries that to do the following: (10 marki). Your queries will be marked based on whether the queries are formulated correct or not, net based on the records that are...

Write MySQL queries, thanks QUESTIONS Ameril parts Comider the following relational schema for a HR database: REGIONS Region RegionName) COUNTRIES Country ID, Country Name, RegionID)...

QUESTION 5 Answer all parts Consider the following relational schema for a HR database: REGIONS(RegionID, RegionName) COUNTRIES(CountryID, CountryName, RegionID) LOCATIONS(LocationID, Address, City,...

SQL CODE: https://gist.githubusercontent.com/GistMasterPro/3893fe6d62ae301e85265a7f0ceafad4/raw/40fe8193dd74c39a56724d8eda2d445e41bc58c7/SQL.sql 30. Write a query to display the first name, last...

SQL CODE: 30. Write a query to display the first name, last name, phone number, title, and department number of employees who work in department 300 or have the title "CLERK I." Sort the output by...

SQL CODE: https://gist.githubusercontent.com/GistMasterPro/3893fe6d62ae301e85265a7f0ceafad4/raw/40fe8193dd74c39a56724d8eda2d445e41bc58c7/SQL.sql OR...

This ratio is the probability that the needle intersects a line. Find the probability that the needle will intersect a line if h = L. What if h = L/2? area under y h sin 0 area of rectangle

Compare the premiums for a 10-year level term policy for $75,000 for a 40-year-old male to the same policy for a 40-year-old female. Use a non-tobacco rate.

QUESTION TWOZwangendawa plc is a listed medium - sized building materials company. Information regardingthe companys financing is given below:Statement of Financial Position ( Balance Sheet ) as at 1...

Shanahan Construction Company has entered into a contract beginning January 1, 2020, to build a parking complex. It has been estimated that the complex will cost $609,000 and will take 3 years to...

Know how to use reservations systems to inventory demand.

Understand how customers perceive waits and how to make waiting less burdensome for them.

Be familiar with the integrative servicescape model.