Editing SQL 2
Jump to navigation
Jump to search
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then publish the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 105: | Line 105: | ||
==== 12-19 EmpDept query ==== | ==== 12-19 EmpDept query ==== | ||
12. output of all employees from department 30 sorted by their salary starting with the highest salary. | 12. output of all employees from department 30 sorted by their salary starting with the highest salary. | ||
13. output of all employees sorted by job and within the job by their salary | 13. output of all employees sorted by job and within the job by their salary | ||
14. output of all employees sorted by their year of employment in descending order and within the year by their name | 14. output of all employees sorted by their year of employment in descending order and within the year by their name | ||
15. output of all salesmen in descending order regarding the ratio commission to salary | 15. output of all salesmen in descending order regarding the ratio commission to salary | ||
16. output the average salary to each department number | 16. output the average salary to each department number | ||
17. calculate the average annual salaries of those jobs that are performed by more than 2 employees | 17. calculate the average annual salaries of those jobs that are performed by more than 2 employees | ||
18. output all department numbers with at least 2 office workers | 18. output all department numbers with at least 2 office workers | ||
19. find the average value for salary and commission of all employees from department 30 | 19. find the average value for salary and commission of all employees from department 30 | ||