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:

House Hunting Expenses

Costs incurred while searching for a new home, often not deductible on U.S. federal tax returns except in specific relocating job circumstances.

Lodging

Accommodation in a residence or hotel for a short-term stay, often considered for deductible travel expenses in business contexts.

Recognized Gain

The portion of a gain on the sale of an asset that must be reported as income for tax purposes.

Divorce Agreement

A legal document that outlines the terms agreed upon by partners during a divorce, including division of assets, child support, and alimony.