Master arithmetic operators: +, -, *, /, % (modulo)

Use numeric functions: ROUND, CEIL, FLOOR, ABS, POWER

Handle NULL in calculations with COALESCE

Apply aggregate functions: SUM, AVG, MIN, MAX, COUNT

Understand operator precedence and parentheses

Prevent integer division and overflow errors

Precision rules: DECIMAL(12,4) for finance vs FLOAT (rounding errors)

Performance costs: Math functions in predicates kill indexes

Master arithmetic operators: +, -, *, /, % (modulo)

Use numeric functions: ROUND, CEIL, FLOOR, ABS, POWER

Handle NULL in calculations with COALESCE

Apply aggregate functions: SUM, AVG, MIN, MAX, COUNT

Understand operator precedence and parentheses

Prevent integer division and overflow errors

Precision rules: DECIMAL(12,4) for finance vs FLOAT (rounding errors)

Performance costs: Math functions in predicates kill indexes