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:

Economic Profit

The difference between the total revenue earned by a business and the total opportunity costs of all resources used in production.

Competitive

Relating to or characterized by rivalry among sellers in a market, aiming to increase sales, market share, and customer loyalty by offering better terms.

Maximum

The highest or greatest possible amount or degree of something.

Long-Run Equilibrium

A state in which all factors of production and inputs in a market are fully adjusted to any economic changes, showing no tendency for further adjustment.