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

“Show me a list of staff members, their salaries, and a proposed 7 percent bonus for each staff member.”

From

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

Note

SELECT CONCAT(StfFirstName, " ", StfLastname) AS StaffMember, Salary, (Salary * 0.07) AS Bonus FROM Staff;