SQRT2 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. A square of squares Description: A square of squares You like building blocks. You especially like building blocks that are squares. And what you even like more, is to arrange them into a square of square building blocks! However, sometimes, you can't arrange them into a square. Instead, you end up with an ordinary rectangle! Those blasted things! If you just had a way to know, whether you're currently working in v.. 2022. 3. 13. 이전 1 다음