코드로 우주평화

This function should test if the factor is a factor of base. Return true if it is a factor or false if it is not. About factors Factors are numbers you can multiply together to get another number. 2 and 3 are factors of 6 because: 2 * 3 = 6 You can find a factor by dividing numbers. If the remainder is 0 then the number is a factor. You can use the mod operator (%) in most languages to check for..

Given a demographics table in the following format: demographics table schema id name birthday race return a single column named calculation where the value is the bit length of name, added to the number of characters in race. Solution: SELECT BIT_LENGTH(name)+ CHAR_LENGTH(race) AS calculation FROM demographics 'BIT_LENGTH' can obtain the bit length. 'CHAR_LENGTH' or 'LENGTH' can obtain the char..

or this challenge you need to create a simple MIN / MAX statement that will return the Minimum and Maximum ages out of all the people. people table schema id name age select table schema age_min (minimum of ages) age_max (maximum of ages) Solution: SELECT MIN(age) AS age_min, MAX(age) AS age_max FROM people Result: age_min age_max 11 99

For this challenge you need to create a simple SELECT statement that will return all columns from the products table, and join to the companies table so that you can return the company name. products table schema id name isbn company_id price companies table schema id name You should return all product fields as well as the company name as "company_name". NOTE: Your solution should use pure SQL...

Clock shows h hours, m minutes and s seconds after midnight. Your task is to write a function which returns the time since midnight in milliseconds. Example: h = 0 m = 1 s = 1 result = 61000 Input constraints: 0

For this challenge you need to create a simple SUM statement that will sum all the ages. people table schema id name age select table schema age_sum (sum of ages) Solution: SELECT SUM(age) AS age_sum FROM people; Result: age_sum 5451

Write a select statement that takes name from person table and return "Hello, how are you doing today?" results in a column named greeting [Make sure you type the exact thing I wrote or the program may not execute properly] Solution: SELECT concat('Hello, ', name, ' how are you doing today?') AS greeting FROM person concat appends string arguments. '||' By using symbols, the same result can be a..

SQL Notes: You will be given a table, numbers, with one column number. Return a table with a column is_even containing "Even" or "Odd" depending on number column values. numbers table schema number INT output table schema is_even STRING Solution: SELECT CASE WHEN number%2=0 THEN 'Even' ELSE 'Odd' END AS is_even FROM numbers In psql, 'if' is 'case when ~ then ~ else ~'.

For this challenge you need to create a simple DISTINCT statement, you want to find all the unique ages. people table schema id name age select table schema age (distinct) NOTE: Your solution should use pure SQL. Ruby is used within the test cases to do the actual testing. Solution: SELECT DISTINCT age FROM people; DISTINCT excludes duplicate values ​​of the corresponding column.

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. ..