Returns the base-10 logarithm of a numeric value expression.
specifies any valid SQL expression that evaluates to a numeric value.
select log10(1.0);
0
select log10(10.0);
1
select log10(100.0);
2