Using SQL Developer:

Lesson 5

1 Display the highest, lowest, sum, and average salary of all employees. Label the columns Maximum, Minimum, Sum, and Average, respectively. Round your results to the nearest whole number.

2 Modify the previous SQL statement to display the minimum, maximum, sum and average salary for each job type.

3 Write a query to display the number of people with the same job. Example: Analyst 2 Clerk 4

4 Determine the number of managers without listing them. Label the column Number of Managers.

5 Write a query that will display the difference between the highest and lowest salaries. Label the column DIFFERENCE.

6 Display the manager number and the salary of the lowest paid employee for that manager. Exclude anyone whose manager is not known. Exclude any group where the minimum salary is less than $1000. Sort the output in descending order of salary.

7 Write a query to display the department name, location name, number of employees, and the average salary for all employees in that department. Label the columns DName, Loc, Number of People, and Salary, respectively. Round the average salary to two decimal places.

8 Create a query that will display the total number of employees and of that total the number who were hired in 1980, 1981, 1982, and 1983. Use appropriate column heading.

9 Create a matrix query to display the job, the salary for that job based on department number, and the total salary for that job for all departments, giving each column an appropriate heading.

I prefer to use the database that uses, emp, sal, etc