Compute on the fly

Question

Compute on the fly

Accepted Answer

You can write arithmetic expressions directly in SELECT. Here quantity * unit_price evaluates to 3 * 15.00 = 45.00 for the row where id = 1. The result column has no name unless you add an alias with AS. Expressions can use +, -, *, /, and parentheses like in any programming language.