Question

How Groups function can be used in MySQL SELECT clause?

Answer 1

The GROUP BY clause returns one row for each group. In other words, it reduces the number of rows in the result set. You often use the GROUP BY clause with aggregate functions such as SUM , AVG , MAX , MIN , and COUNT . The aggregate function that appears in the SELECT clause provides the information about each group.

Hope this helps you. please mark me as brainlist and follow me.