What are aggregate and scalar functions?

Aggregate functions are used to evaluate mathematical calculation and return single values. This can be calculated from the columns in a table. Scalar functions return a single value based on the input value.
 Example -.
 Aggregate – max(), count – Calculated with respect to numeric.
 Scalar – UCASE(), NOW() – Calculated with respect to strings.