O'Reilly logo
  • Wiktor Bojanowski thinks this is interesting:

“Display for each agent the agent name and projected income (salary plus commission), assuming each agent will sell $50,000 worth of bookings.”

From

Cover of SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, Fourth edition

Note

SELECT CONCAT (AgtFirstName, " ", AgtLastName) AS AgtName, Salary + (CommissionRate * 50000) AS Income FROM Agents;