# Calculated data and useful functions

This section of the course is designed to creating fields that use calculated values and common functions in SQL. There are five lessons included in this section:

- Calculating fields on the fly
- Using aggregate functions
- Grouping the results of aggregate functions
- Using scalar functions
- Formatting the now time

In this section we will use the following SQL functions:

- AVG()
- COUNT()
- FIRST()
- LAST()
- MAX()
- MIN()
- SUM()
- GROUP BY
- UCASE()
- LCASE()
- LEN()
- ROUND()
- NOW()
- CURDATE()
- CURTIME()
- FORMAT()