Question: Write a query to get the maximum salary employee. Write a query to get the average salary of Clerk Write a query to get the

Write a query to get the maximum salary employee. Write aquery to get the average salary of Clerk Write a query to

  1. Write a query to get the maximum salary employee.
  2. Write a query to get the average salary of Clerk
  3. Write a query to get the average salary of department number 30
  4. Write a query to get the minimum salary of department number 30, the salary should add commission
  5. Count the number of employees in the Sales department. Use sub queries.
  6. Write a query to get the average salaries of all departments. Show the department number along with the average salary.
  7. Write a query to display all the employees that have the same JOB as SMITH and have salaries greater than 1000. (use subquery)

IN SQL

Do these tasks in as simple way as possible and if all tasks done correctly i will surely give thumbs up.

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO 300 500 7369 SMITH 7499 ALLEN 7521 WARD 7566 JONES 7654 MARTIN 7698 BLAKE 7782 CLARK 7788 SCOTT 7839 KING 7844 TURNER 7876 ADAMS 7900 JAMES 7902 FORD 7934 MILLER 1400 CLERK SALESMAN SALESMAN MANAGER SALESMAN MANAGER MANAGER ANALYST PRESIDENT SALESMAN CLERK CLERK ANALYST CLERK 7902 17-DEC-80 7698 20-FEB-81 7698 22-FEB-81 7839 02-APR-81 7698 28-SEP-81 783901-MAY-81 7839 09-JUN-81 7566 09-DEC-82 17-NOV-81 7698 08-SEP-81 7788 12-JAN-83 7698 03-DEC-81 7566 03-DEC-81 7782 23-JAN-82 800 1600 1250 2975 1250 2850 2450 3000 5000 1500 1100 950 3000 1300 20 30 30 20 30 30 10 20 10 30 20 30 20 10 EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO 300 500 20 30 30 20 1400 7369 SMITH 7499 ALLEN 7521 WARD 7566 JONES 7654 MARTIN 7698 BLAKE 7782 CLARK 7788 SCOTT 7839 KING 7844 TURNER 7876 ADAMS 7900 JAMES 7902 FORD 7934 MILLER CLERK SALESMAN SALESMAN MANAGER SALESMAN MANAGER MANAGER ANALYST PRESIDENT SALESMAN CLERK CLERK ANALYST CLERK 7902 17-DEC-80 7698 20-FEB-81 7698 22-FEB-81 7839 02-APR-81 7698 28-SEP-81 7839 01-MAY-81 7839 09-JUN-81 7566 09-DEC-82 17-NOV-81 7698 08-SEP-81 7788 12-JAN-83 7698 03-DEC-81 7566 03-DEC-81 7782 23-JAN-82 800 1600 1250 2975 1250 2850 2450 3000 5000 1500 1100 950 3000 1300 30 30 10 20 10 30 20 30 20 10 DEPTNO DNAME LOC 10 ACCOUNTING 20 RESEARCH 30 SALES 40 OPERATIONS 10 ACCOUNTING 20 RESEARCH 30 SALES 40 OPERATIONS NEW YORK DALLAS CHICAGO BOSTON NEW YORK DALLAS CHICAGO BOSTON

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:

Write a query to get the maximum salary employee. Write a query to get the average salary of Clerk Write a query to get the average salary of department number 30 Write a query to get the minimum...

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:

Each primary key is specified with a key icon. The one - to - many relationships are specified by using Note that in this question, the names of foreign key are coincidentally the same as the names...

Q:

Write a query to get the average salary and the total number of employees who work in the Accounting department (in that order). Write a query to get the number of employees working in the Marketing...

Q:

Write a query to get the average salaries of jobs grouped by their department number. List all employees in the Sales, and Operations departments using subquery. Write a query to get the maximum...

Q:

Lab - 6 Aggregate Functions 1. Create a SQ 2 Create a sQL query to get the average salary for all departments employing more than 10 employees 3 Create SQL a query to get the total salary, maximum,...

Q:

In AWS RDS, create an MySQL database instance (Free tier), following the recording pro- vided in Week3. (Set the inbound IP address to 0.0.0.0, which make it accessible from any- where) attach a...

Q:

MYSQL THE TABLE IS HERE: 1. Write a query to get unique department ID from employee table. Excel file attached. 2. Write a query to get the details of all employees according to first name in...

Q:

Please upload your text file containing the queries used, thank you. 1. 2. 3. 4. EMPIOYEE DEPARTMENT DEPT_LOCATIONS WORKS ON PROJECT DEPENDENT Write a query to find the total salary paid in each...

Q:

For those fortunate souls who do not need glasses, the lens ofthe eye adjusts its focal length in order to form a proper image onthe retina. This typically means that very distant objects as wellas...

Q:

Which summary measure(s) may be used on a. Nominal data? b. Ordinal data? c. Quantitative data?

Q:

What is the minimum annual dividend distribution requirement for a publicly traded corporation? Multiple choice question. Corporations must distribute at least 5 percent of net income. Corporations...

Q:

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...