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:

Verified
Correct Answer:
Verified
Q31: How can you improve your SQL skills?<br>A)Practice
Q32: What would you most likely use in
Q33: Based on the table description and SQL
Q34: A good name for an Access table
Q35: When you connect query conditions using the
Q37: Based on the SQL shown, which query
Q38: Explain how to use three SQL clauses
Q39: While not always required, how should you
Q40: In Access SQL, you use the asterisk
Q41: In Access SQL, which operator do you