group by in sql example

Example 1: select query group by name

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

Example 2: sql group by example

SELECT column_name(s)
  FROM table_name
  WHERE condition
  GROUP BY column_name(s)
  HAVING condition
  ORDER BY column_name(s);