kyu8_EASY_SQL_square_root_and_log.sql

-- Square root and log;
--
-- https://www.codewars.com/kata/594a691720ac16a544000075
--
-- 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

SELECT sqrt(number1) AS root, log(number2) AS log FROM decimals;