Describe Various Types of Functions Available in SQL

SQL functions are broadly divided into those that calculate and return a value for
every row in a data set and those that return a single aggregated value for all rows.
The following two areas are explored:
■ Defining a function
■ Types of functions