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:

Vertebrae

The individual bones that make up the vertebral column or spine, providing structural support to the body and protecting the spinal cord.

Coccyx

The small, triangular bone at the base of the spinal column, often called the tailbone.

Sacrum

A large, triangular bone at the base of the spine, below the lumbar vertebrae and above the coccyx, forming part of the pelvis.

Blood Pressure

The force exerted by circulating blood on the walls of blood vessels, often measured for diagnostic purposes.