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)

4. Create a report to display the last name, job ID, and hire date for employees with the last names of Matos and Taylor. Order the Query in ascending order by the hire date JOB_1DB ST_CLERK 15-MAR-98 SA REP 24-MAR-98 LAST-NAME HIRE-DATE 1 Matos 2 Taylor 5. Display the last name and department ID for all employees in departments 20 or 50 in ascending Alphabetical order by name. LAST NAMEDEPARTMENT ID 50 20 1 Davies 2 Fay 3 Hartstein 4 Matos 5 Mourgos 6 Rajs 7 Vargas 20 50 50 50 50 6. Modify the query in Question 3 to display the last name and salary of employees who earn between $5,000 and $12,000 and are in department 20 or 50. Label the columns Employee and Monthly Salary, respectively. 1 Fay 2 Mourgos Employee Monthly Salary 6000 5800

Solution

4.
SELECT LAST_NAME, JOB_ID, HIRE_DATE
FROM Employees
WHERE LAST_NAME IN(\'Matos\',\'Taylor\')
ORDER BY HIRE_DATE

5.
SELECT LAST_NAME,DEPARTMENT_ID
FROM Employees
WHERE DEPARTMENT_ID IN(20,50)
ORDER BY lastName

6.
SELECT LAST_NAME as Employee, salary as Monthly Salary
FROM Employees
WHERE salary > 5000 and salary < 12000 and DEPARTMENT_ID IN(20,50)