Based on the SQL Shown, Which Query Selects the LastName

question 37

Multiple Choice

Based on the SQL shown, which query selects the LastName, JobTitle, and increased bonus for all employees with a job title of SalesRep? The increased bonus is calculated as $100 more than the current bonus. Employees ( EmployeeID, LastName, FirstName, HireDate, JobTitle, Bonus )

• A)SELECT LastName, JobTitle, Bonus FROM Employees WHERE JobTitle = 'SalesRep' AND IncreasedBonus = Bonus + 100;
• B)SELECT LastName, JobTitle, Bonus AS IncreasedBonus + 100 FROM Employees WHERE JobTitle = 'SalesRep';
• C)SELECT * FROM Employees WHERE IncreasedBonus = Bonus + 100;
• D)SELECT LastName, JobTitle, Bonus + 100 AS IncreasedBonus FROM Employees WHERE JobTitle = 'SalesRep';

---

Definitions:

Motivate Employees

The act of inspiring and encouraging workers to perform their duties effectively and with enthusiasm.

Valued Outcomes

Results or end-states that are deemed important, beneficial, or of significant worth by a person or group.

Expectancy Theory

A motivational theory suggesting that individuals are more likely to be motivated to perform if they believe that their efforts will lead to desirable outcomes.

Test

A method of assessing a person's knowledge, performance, or ability in a particular area, often used in educational and professional settings.