Based on the SQL shown, which query selects the LastName, JobTitle, and increased bonus for all employees with a job

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’;

Leave a Reply

Your email address will not be published.