Which of the following statements is true regarding the GROUP BY clause?

All the other statements are false.

A group by operation automatically sorts the results

Columns in the group by clause must also appear in the WHERE clause

columns in the SELECT clause that are not aggregated must appear in the GROUP BY clause