LOG

1
SELECT
2
  value,
3
  LOG(value) as natural_log,
4
  LOG(10, value) as log_base_10,
5
  LOG(2, value) as log_base_2
6
FROM (SELECT unnest([1, 10, 100, 1000]) as value);

1
SELECT
2
  year,
3
  revenue,
4
  LOG(revenue / LAG(revenue) OVER (ORDER BY year)) as log_growth
5
FROM company_revenue
6
WHERE year >= 2020;

1
SELECT
2
  category,
3
  total_sales,
4
  ROUND(LOG(10, total_sales), 2) as log_scale,
5
  ROUND(LOG(10, total_sales) * 10, 0) as score
6
FROM category_sales
7
ORDER BY total_sales DESC;