Numeric Functions

SELECT ABS(-5) -- 5
SELECT ABS(balance) AS absolute_balance FROM company_data."123"

SELECT CEIL(4.2)  -- 5
SELECT CEIL(-4.2) -- -4

SELECT FLOOR(4.8)  -- 4
SELECT FLOOR(-4.2) -- -5

SELECT ROUND(4.567)     -- 5
SELECT ROUND(4.567, 2)  -- 4.57
SELECT ROUND(4.567, 0)  -- 5

SELECT POWER(2, 3) -- 8
SELECT POW(10, 2)  -- 100

SELECT SQRT(16) -- 4
SELECT SQRT(2)  -- 1.414...

SELECT LN(2.718281828) -- ~1

SELECT LOG10(100) -- 2

SELECT EXP(1) -- 2.718...

SELECT MOD(10, 3) -- 1
SELECT MOD(user_id, 100) AS bucket FROM company_data."123"

SELECT GREATEST(1, 5, 3) -- 5
SELECT GREATEST(score1, score2, score3) AS max_score FROM company_data."123"

SELECT LEAST(1, 5, 3) -- 1
SELECT LEAST(price1, price2) AS min_price FROM company_data."123"