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:

Source

The origin from which something comes, such as information or material for academic or production purposes.

In-Kind Benefits

Benefits given in the form of goods or services rather than money, often used in social welfare programs.

Poverty Rate

The percentage of the population living below the national poverty line, indicating the proportion of people who cannot afford basic needs.

Absolute Income Scale

A measure of an individual’s or household’s income level, without adjusting for inflation or cost-of-living differences.