Question: what is difference between group functions and single row functions?
Answer: A single row function returns a single result row for every row of a queried table or view, while a group function returns a single result row for a group of queried rows.