SQL Developer

The common requirements of all questions are the same. Read each question carefully and submit an appropriate query to fulfill for each question. Also, students need to provide screenshot(s) of the query result copied and pasted as it is printed on the screen without any modification. If necessary, the column names appearing in the result should be converted appropriately using "AS" in statement. Don't delete or change questions. You just need to insert both your TEXT query and captured screenshot result under your query under the corresponding query. The query result should be 1. HR Manager is interested in collecting minimum and maximum salary of each job. Also, the manager wants to see the results in a report sorted from high to low sequence of minimum salary. (5 points) 2. HR manager wants to make a report which shows average salary of each departmemt. Thus, your query result should show at least the average salary and department id. (10 points) 3. HR manager wants to make a report which shows maximum salary of each department. (5 points) 4. H R manager wants to make a job title. (5 points) report which shows actual minimum of each job and 5. HR manager wants to make a report which contains 4 columns "Job title, Average Salary Minimum Salary, Maximum Salary". Also, he wants the report to be sorted by Average Salary from high to row. (10 points) 6. The HR manager wants to group the salaries and commissions of the salesperson to see how many salespersons belong to the group of salary and commission Include distinctive salary, commission, and the number of employees in your report Also, subtotal should be in included in the report. (15 points)