qcakmG2L

1use Media;
2DROP table if exists users;
3create table users(
4	/*id int unsigned NOT NULL,*/
5    id serial primary key,
6    name varchar(255) COMMENT 'name',
7    birthday_at DATE COMMENT 'Дата рождения'
8) COMMENT = 'Юзеры';
9
10INSERT INTO users (id, name, birthday_at) 
11values
12	(null, 'Александр', '1968-01-20'),
13    (null, 'Михаил', '1998-01-21' ),
14	(Null, 'Илья', '1987-03-25'),
15    (null, 'Уася', '1987-03-25'),
16    (null, 'Михаил', '1996-02-22' ),
17    (null, 'Kate', '1998-01-21' ),
18    (null, 'Max', '1998-02-21' ),
19    (null, 'Smith', '1998-03-23' );
20
21select 
22ANY_VALUE(name),
23weekday(birthday_at) as week,
24count(*) 
25 from users
26 Group by week;