Expressions can be formed
for the operations using the symbols
addition +
subtraction -
multiplication *
division /
Column names (speed * time), constants (speed * 1.01), and functions related to a whole column, such as (AVG (account - 500)), can be used. An expression can be a numeric constant or a character value.
Furthermore, the following functions are provided:
A DIV B for the integer division of A by B
A MOD B for the remainder of an integer division of A by B