Solved

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

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions