log2 Easy SQL: Absolute Value and Log to Base Given the following table 'decimals': decimals table schema id number1 number2 Return a table with two columns (abs, log) where the values in abs are the absolute values of number1 and the values in log are values from number2 in logarithm to base 64. Solution: SELECT ABS(number1), LOG(64, number2) FROM decimals Result: abs log 2849.529276973034 0.5513855124091469e1 168.16728863472508 0.53183827.. 2022. 6. 16. Easy SQL: Square Root and Log Given the following table 'decimals': ** decimals table schema ** id number1 number2 Return a table with two columns (root, log) where the values in root are the square root of those provided in number1 and the values in log are changed to a base 10 logarithm from those in number2. Solution: SELECT SQRT(number1) AS root, LOG(number2) FROM decimals; SQRT is a function that finds the square root. .. 2022. 5. 17. 이전 1 다음