We have started having fun with built-in functions (set of instructions) for numeric values.

1. SUM() — total value of row
2. AVG() — average value of a row
3. COUNT() — how many records
4. ROUND() — rounding a number to a specific decimal point (decimal, float, double, money…)
5. CEILING() — rounding up to the closest whole number value (integer)
6. FLOOR() — rounding down to the closest whole number value (integer)
7. MAX() — highest value
8. MIN() — lowest value
9. RAND() — random value
10. FORMAT() — “dress” value for date or currency ($5.00, 2/14/2018, 14-FEB-18); outputs VARCHAR(n)

Download the notes for day 3.