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

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 employee who earns a salary greater than the average salaries for department 50. 1 pts

Q3) display the department names and ids that is located in the country United States of America. 1pts

Q4) 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!

Q:

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

Q:

Write SQL queries to answer the following questions: Write a query to list the employees first, and last name as well as their hire date and commission _ pct . If the commission _ pct is empty report...

Q:

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

Q:

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

Q:

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

Q:

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

Q:

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

Q:

please answer quick using hr.employees from oracle live sql 1. Write a query to display the name ( first name and last name ) for those employees who gets more salary than the employee whose ID is...

Q:

***********PLEASE USE THIS TABLES************ DROP TABLE EMP; DROP TABLE DEPT; DROP TABLE SALGRADE; create table dept( deptno number(2,0), dname varchar2(14), loc varchar2(13), constraint pk_dept...

Q:

DBS 3 1 1 Advanced Data Services Last update: Summer 2 0 2 4 Advanced Databae Services Assignment 1 SubmissionYour submission will be a single text - based SQL file ( . sql ) with appropriate header...

Q:

Complete the following questions: a) Which loan has higher periodic payments and why? (You can convert monthly payments in the CBA offer into quarterly payments by multiplying monthly payments to 3)....

Q:

Consider the chemical equilibrium involving H2O, H2, CO, and CO2, and no other substances. Show that the equilibrium constant at any temperature can be found using values from Table A.10 only.

Q:

The Walt Disney Company Discounted Cash Flow Method - Fill in the chart for all years listed below

Q:

The Whispering Corporation issued 10-year, $4,440,000 par, 7% callable convertible subordinated debentures on January 2, 2022. The bonds have a par value of $1,000, with interest payable annually....

Q:

2. How will the team select a leader?

Q:

1. Provide clear, defined direction and remove all ambiguity from the process.

Q:

3. What may be the goal of the team?