Based on the SQL Shown, Which Query Lists the Last

question 36

Multiple Choice

Based on the SQL shown, which query lists the last names and bonuses of employees who have a Bonus field value greater than Juliana Suarez, EmployeeID 14? Employees ( EmployeeID, LastName, FirstName, HireDate, JobTitle, Bonus )

• A)SELECT LastName, Bonus FROM Employees WHERE Bonus >(SELECT Bonus FROM Employees WHERE EmployeeID = '14');
• B)SELECT LastName, Bonus FROM Employees HAVING Bonus > EmployeeID = '14';
• C)SELECT LastName, Bonus FROM Employees WHERE Bonus > UNION (SELECT LastName, Bonus FROM Employees WHERE EmployeeID = '14');
• D)SELECT LastName, Bonus FROM Employees WHERE Bonus > UPDATE SET EmployeeID = '14';

---

Definitions:

Interface

A point where two systems, subjects, organizations, etc., meet and interact.

Fraudulently

Acting with intent to deceive or cheat, often for personal gain or to fulfill some unlawful purpose.

Laser Printer

A type of printer that uses a laser and toner to create high-quality text and graphics on paper.

Misrepresentation

A false statement of fact made by one party to another party, which has the effect of inducing that party into a contract.