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.”


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


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