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';

Question

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';

Quizplus · Accepted Answer

The correct query uses a subquery to select the bonus of Juliana Suarez (EmployeeID = 14) and then compares this value to the bonuses of other employees to find those with a higher bonus.

Based on the SQL Shown, Which Query Lists the Last