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');
Transcribed Image Text:
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
23
07-Feb-19
11-Mar-19
10-Apr-20
02-Sep-19
06-Jan-20
10-Feb-20
31-Mar-21
30-Apr-20
30-Nov-20
09-Dec-20
21-Dec-20
04-Jan-21
15-Feb-21
14-Apr-21
04-Jun-21
30-Jul-21
31-Aug-21
30-Sep-21
12-Nov-21
2
3
4
2
3
6
7
9
10
15
14
11
12
6
13
1
16
20
18
52
63
52
52
63
52
63
19
19
64
19
19
52
52
63
52
63
19
19
63
ProjectNotes
Client wants digital solutions to help rebrand company name to
emphasize commercial real estate.
Client needs help converting, organizing, and managing various
sources/formats of donor and donation data.
Client wants to establish SEO goals.
Client wants to set up an internal server as well as help
with a domain name.
Client has used the database for several months and
now needs new report
Develop and implement website SEO strategy.
Needs help to manage and organize internal data.
Develop new website content.
Client needs internal database to manage personnel.
Client needs subcontracting help installing a new database for a
WordPress site.
Client needs new functionality for current JavaScript application.
Client needs new functionality for current Ruby/Rails application.
Client needs help with server security.
Current online sales solution is unreliable.
Client needs internal database to manage inventory.
Client needs new functionality for current C# / ASP.NET application.
Client needs full website reskin.
Client needs help with data analytics.
Client needs an online reference database
Client needs new blog and current pages updated to include
responsive web design principles for mobile devices.