wyAtTmArK19
New member
- Nov 29, 2009
- 1
- 0
- 1
1. Create a query that displays the employee names, and indicates the amount of their salaries through asterisks. Each asterisks signifies a hundred dollars. Sort the data in descending order of salary. Label the column "Employees and their Salaries".
example answer:
Employees and their Salaries
------------------------------------------------
SMITH******************
KING***********************
WARD************************
JONES*************************
2. Display the manager number and salary of the lowest paid employee for that manager. Exclude anyone whose manager is not known. Exclude any groups where the minimum salary is less than $1000. Sort the output in descending order by salary.
MGR MIN(SAL)
------------------------------------
7566 3000
7782 1300
7839 2450
7788 1100
3. Create a query to display the department name, location, number of employees, and the average salary for all employed in the department. Label the column DNAME, LOC, Number of People, and Salary, respectively. Round the ave. by 2 places.
DNAME LOC Number of People Salary
---------------------------------------------------------------------------------
ACCOUNTING NEW YORK 3 2916.67
example answer:
Employees and their Salaries
------------------------------------------------
SMITH******************
KING***********************
WARD************************
JONES*************************
2. Display the manager number and salary of the lowest paid employee for that manager. Exclude anyone whose manager is not known. Exclude any groups where the minimum salary is less than $1000. Sort the output in descending order by salary.
MGR MIN(SAL)
------------------------------------
7566 3000
7782 1300
7839 2450
7788 1100
3. Create a query to display the department name, location, number of employees, and the average salary for all employed in the department. Label the column DNAME, LOC, Number of People, and Salary, respectively. Round the ave. by 2 places.
DNAME LOC Number of People Salary
---------------------------------------------------------------------------------
ACCOUNTING NEW YORK 3 2916.67