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:

Implied Authority

This refers to the power of an agent to perform acts which are reasonably necessary to accomplish the purpose of an organization’s agency agreement, even if not explicitly granted.

Duty of Accounting

The obligation of a party (usually a fiduciary) to keep accurate records and report financial activity to relevant stakeholders or authorities.

Agent Owe

The duty or obligation an agent has to act in the best interest of the principal, including loyalty, care, and full disclosure.

Principal

In finance, the principal is the initial amount of a loan or the amount of an investment excluding any interest or profit earned.