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

“What if we adjusted each product price by reducing it 5 percent?”

From

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

Note

SELECT ProductNumber, ProductName, RetailPrice, RetailPrice - (RetailPrice * 0.05) AS RetailPriceAdjusted FROM Products;