SQL Taskbook Level 1.8
Given a table:
| id | number1 | number2 | number3 |
|---|---|---|---|
| 1 | 1 | 2 | 3 |
| 2 | 3 | 4 | 5 |
| 3 | 6 | 7 | 8 |
Solve the following tasks for it:
Задание 1
Find the remainder when divided by 2 for each column number1 from this table.
Задание 2
Find the remainder when divided by 3 for each number2 column of this table.
Задание 3
Find the remainder when you divide column number3 by column number1 from this table.
Задание 4
Find the square root for each value in the number3 column from this table and round it.
Задание 5
Match each value in column number3 to each value in column number1 from this table.
Задание 6
Find a random value for each column in this table.