SQL Taskbook Level 1.6
Given a table:
| id | user_id | product_id | amount | date |
|---|---|---|---|---|
| 1 | 2 | 2 | 150.50 | 2020-03-17 |
| 2 | 3 | 2 | 200.60 | 2017-08-31 |
| 3 | 4 | 4 | 700.10 | 2011-05-03 |
| 4 | 5 | 3 | 300.40 | 2005-12-31 |
| 5 | 5 | 3 | 650.70 | 2000-12-02 |
Solve the following tasks for it:
Find the minimum value of the amount column from this table.
Find the maximum value of the amount column from this table.
Find the average of the amount column values from this table.
Find the average of the amount column values from this table and round that value.
Find the sum of the amount column from this table and round this value to one decimal place.
Find the average value of the amount column from this table and round this value up.
Find the average value of the amount column from this table and round that value down.
Find the sum of the amount column from this table and make it so that there are 4 digits after the decimal point.
