Distinction should include
- single-row functions, which return a result (e.g., character, number, date, conversion) for a selected row
- group functions (aggregate functions), which select multiple rows of data but return only one result (i.e., AVG, COUNT, MAX, MIN, STDDEV, SUM, VARIANCE).