Problem 2 For the following problems screenshot your code o

Problem 2 - For the following problems screenshot your code only (not the view output, you will be given that)

Create a report to display the last name, salary, and commission of all employees who earn commissions Sort the data in descending order of salary and commissions. Use the column\'s numeric position in the ORDER BY clause. SALARY 11000 10500 8600 7000 COMMISSION-PCT 0.3 0.2 0.2 0.15 LAST_NAME 1 Abel 2 Zlotkey 3 Taylor 4 Grant Members of the HR department want to have more flexibility with the queries that you are writing. They would like a report that displays the last name and salary of employees who earn more than an amount that the user specifies after a prompt. If you enter 12000 when prompted the report displays the following results: 10. LAST NAME SALARY LASTNAME SALARY 13000 24000 17000 17000 - 1 Hartstein 2 King 3 Kochhar 4 De Haan

Solution

9.
SELECT LAST_NAME, SALARY, COMMISSION_PCT
FROM Employees
WHERE COMMISSION_PCT > 0
ORDER BY COMMISSION_PCT,SALARY DESC

10.
SELECT LAST_NAME, SALARY
FROM Employees
WHERE SALARY > @input

I\'m not sure how input will work in the database environment you are using.
Ideally stored procedure can be used in SQL Server.