GROUP BY is an example of aggregate function.

Example: select query group by name

SELECT `gender` FROM `members` GROUP BY `gender`;