For the following problems screenshot your code only (not the view output, you w

Question

For the following problems screenshot your code only (not the view output, you will be given that) The HR department needs your assistance in creating some queries. Because of budget issues, the HR department needs a report that displays the last name and salary of employees who earn more than $12,000. Open a new SQL Worksheet. Create a report that displays the last name and department number for employee number 176. Run the query. The HR department needs to find high-salary and low-salary employees. Modify the query in Question 1 to display the last name and salary for any employee whose salary is not in the range of $5,000 to $12,000.

Explanation / Answer

Since nothing is given, I am assuming the table name is employee

1.

SELECT LAST_NAME, SALARY
FROM employee
WHERE SALARY > 12000

2.
SELECT LAST_NAME, DEPARTMENT_ID
FROM employee
WHERE EMPLOYEE_ID = 176

3.
SELECT LAST_NAME, SALARY
FROM employee
WHERE SALARY > 12000 OR SALARY < 5000

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.