Which of the following correctly describe the aggregate functions?
It returns a single result row based on single rows
It returns a single result row based on groups of rows
It can only appear in ORDER BY clauses
It cannot appear in select lists