MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE metrics (
  id int(11) NOT NULL AUTO_INCREMENT,
  date date NOT NULL,
  value int(11) NOT NULL,
  PRIMARY KEY (id)
) ENGINE InnoDB AUTO_INCREMENT=1 CHARSET=utf8mb4;

INSERT INTO metrics (date, value)
VALUES 
    ('2022-04-01', 1),
    ('2022-04-02', 1),
    ('2022-04-03', 1),
    ('2022-04-04', 1),
    ('2022-04-05', 1),
    ('2022-04-06', 1),
    ('2022-04-07', 1),
    ('2022-04-08', 1),
    ('2022-04-09', 1),
    ('2022-04-10', 1),
    ('2022-04-11', 1),
    ('2022-04-12', 1),
    ('2022-04-13', 1),
    ('2022-04-14', 1);
select 
  id,
  date,
  weekday(date) day,
  week(date) "week",
  value
from metrics


id
date
day
week
value


1
2022-04-01
4
13
1

2
2022-04-02
5
13
1

3
2022-04-03
6
14
1

4
2022-04-04
0
14
1

5
2022-04-05
1
14
1

6
2022-04-06
2
14
1

7
2022-04-07
3
14
1

8
2022-04-08
4
14
1

9
2022-04-09
5
14
1

10
2022-04-10
6
15
1

11
2022-04-11
0
15
1

12
2022-04-12
1
15
1

13
2022-04-13
2
15
1

14
2022-04-14
3
15
1


select
  week(date) "week",
  sum(value) "value"
from metrics
group by week(date)
order by week(date);


week
value


13
2

14
7

15
5

id	date	day	week	value
1	2022-04-01	4	13	1
2	2022-04-02	5	13	1
3	2022-04-03	6	14	1
4	2022-04-04	0	14	1
5	2022-04-05	1	14	1
6	2022-04-06	2	14	1
7	2022-04-07	3	14	1
8	2022-04-08	4	14	1
9	2022-04-09	5	14	1
10	2022-04-10	6	15	1
11	2022-04-11	0	15	1
12	2022-04-12	1	15	1
13	2022-04-13	2	15	1
14	2022-04-14	3	15	1