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:

Peer Delinquent Subculture

An antisocial youth subculture.

Antisocial

Behaviors or attitudes that go against social norms, often harming others or lacking consideration for others' wellbeing.

Panhandling

The act of begging in public places, often seen on streets or near public transports.

Economically Disadvantaged

Describes individuals or groups who have less economic resources and opportunities than the average level in society.