Which SQL clause bundles rows sharing a value to produce a sum or an average?

• WHERE
• JOIN
• GROUP BY
• DISTINCT

Without signing in you can answer just this one question.