Question

We can use the group functions to return summary information for each
O
row
O
group
Oo oo
column
group by​

Answer 1

Answer:

Row

Explanation:

Answer 2

Answer: Row

Explanation:

Group functions can be nested only to a depth of two. Group functions can be nested inside single-row functions (AVG embedded in a TO_CHAR function). In addition, single-row functions can be nested inside group functions.

Group functions are mathematical functions to operate on sets of rows to give one result per set. The types of group functions (also called aggregate functions) are:

• AVG, which calculates the average of the specified columns in a set of rows,
• COUNT, calculating the number of rows in a set.
• MAX, calculating the maximum,
• MIN, calculating the minimum,
• STDDEV, calculating the standard deviation,
• SUM, calculating the sum,
• VARIANCE, calculating the variance.

#SPJ3