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

TotalLength + CAST(Distance AS INTEGER)

From

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

Note

MySQL example:

SELECT (CAST(QuotedPrice AS INTEGER) * QuantityOrdered) AS TotalPrice FROM Order_Details WHERE OrderNumber = 1;