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:
Find the remainder when divided by 2 for each column number1 from this table.
Find the remainder when divided by 3 for each number2 column of this table.
Find the remainder when you divide column number3 by column number1 from this table.
Find the square root for each value in the number3 column from this table and round it.
Match each value in column number3 to each value in column number1 from this table.
Find a random value for each column in this table.
