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

“What is the net amount for each of our contracts?”

From

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

Note

SELECT EngagementNumber, ContractPrice, (ContractPrice * 0.12) AS OurFee, (ContractPrice -(ContractPrice * 0.12)) AS NetAmount FROM Engagements;