Customer data is stored in the member table of the following structure:

Поле Описание member_id Уникальный идентификатор клиента member_last_name Фамилия member_first_name Имя member_patronymic Отчество member_sex Пол (1-м, 0 - ж) member_birthday дата рождения (необязательное поле, может быть null)

Write a request, issuing a layout of customers by year of birth and sex:

 Год рождения Пол Кол-во клиентов в базе 1980 Ж 120 1980 М 150 1981 Ж 220 1981 М 350
  • one
    It does not differ from receiving quantities for one field, just to specify two fields in the group by. And what did you try to do before asking a question? - Mike
  • @Mike It seems that lazy students, who are still on the result, would have gotten too far behind the lecturer. - Zverev Evgeniy

1 answer 1

 SELECT year(`member_birthday`), `member_sex`, COUNT(`member_sex`) FROM members GROUP BY year(`member_birthday`), `member_sex` WHERE `member_birthday`