More math
SQL provides the ability to perform many more mathematical operations which are beyond the scope of this introductory course, including:
LOG()
- Return the natural logarithm of a numberABS()
- Return the absolute value of a numberSQRT()
- Return the square root of a numberPOWER(number, power_to_raise to)
- Take a number and return the value of that number, raised to a specified power- Trigonometric functions like
SIN()
andCOS()