Which SQL statement lists the last names and salaries of employees who have a Salary field value

Question:

Which SQL statement lists the last names and salaries of employees who have a Salary field value less than Amir Nasser, EmployeeID 72?

a. SELECT LastName, Salary FROM Employees WHERE Salary

UNION SELECT LastName, Salary FROM Employees WHERE EmployeeID = '72';

b. SELECT LastName, Salary FROM Employees WHERE Salary

UPDATE SET EmployeeID = '72';

c. SELECT LastName, Salary FROM Employees HAVING Salary

d. SELECT LastName, Salary FROM Employees WHERE Salary

(SELECT Salary FROM Employees WHERE EmployeeID = '72');ProjectID ProjectStartDate ClientID EmployeelD 06-Feb-19 1 1 2 3 4 7 9 10 11 13 14 15 16 17 18 19 20 222 21

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Concepts Of Database Management

ISBN: 9780357422083

10th Edition

Authors: Lisa Friedrichsen, Lisa Ruffolo, Ellen Monk, Joy L. Starks, Philip J. Pratt

Question Posted: