MySQL 8.0

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

CREATE TABLE `requests` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `user_id` INT NULL DEFAULT NULL,
  `ip` VARCHAR(32) NULL DEFAULT NULL,
  `at` DATETIME NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
);
INSERT INTO requests(user_id, ip, at) VALUE 
(0, '28.249.36.119', '2021-05-23 23:11:12'), 
(0, '213.127.38.238', '2021-09-23 8:45:08'), 
(18, '28.249.36.119', '2021-07-24 1:33:55'), 
(0, '138.217.106.9', '2021-09-21 22:30:13'), 
(0, '175.119.240.52', '2021-03-12 11:34:45'), 
(0, '120.81.241.239', '2021-04-8 1:55:34'), 
(0, '28.249.36.119', '2021-05-30 7:17:20'), 
(18, '223.196.139.248', '2021-09-11 5:38:29'), 
(27, '205.206.101.128', '2021-08-6 8:24:12'), 
(26, '120.81.241.239', '2021-05-28 17:35:04'), 
(0, '178.26.16.59', '2021-04-2 14:11:55'), 
(0, '242.132.132.7', '2021-11-22 19:48:59'), 
(2, '113.247.142.205', '2021-07-24 2:32:52'), 
(14, '129.42.187.115', '2021-05-13 14:13:17'), 
(18, '241.224.51.109', '2021-04-22 2:43:23'), 
(0, '181.138.231.193', '2021-09-21 10:56:02'),
 (18, '202.129.109.184', '2021-11-17 3:31:23'),
 (22, '202.129.109.184', '2021-03-18 11:29:57'),
 (26, '52.231.122.64', '2021-02-6 2:40:26'), 
(26, '204.163.242.241', '2021-08-20 10:34:56'), 
(24, '223.196.139.248', '2021-05-5 14:06:14'),
 (18, '202.129.109.184', '2021-10-10 9:56:27'),
 (0, '213.127.38.238', '2021-03-21 6:52:54'), 
(14, '202.129.109.184', '2021-09-7 5:54:54'), 
(25, '77.132.236.152', '2021-05-28 10:37:45'), 
(30, '97.0.127.186', '2021-03-4 14:56:36'), 
(25, '163.29.165.120', '2021-10-7 19:38:39'), 
(8, '216.179.174.135', '2021-05-27 9:04:07'), 
(25, '205.206.101.128', '2021-07-16 6:43:04'),
 (1, '57.193.133.133', '2021-07-5 20:11:38'), 
(13, '52.73.250.35', '2021-02-12 11:31:40'), 
(2, '225.133.53.175', '2021-01-29 5:19:57'), 
(0, '94.52.178.105', '2021-08-10 14:56:01'), 
(26, '213.127.38.238', '2021-07-6 14:29:53'),
 (0, '133.205.168.233', '2021-06-8 13:13:08'),
 (0, '213.127.38.238', '2021-09-11 1:29:38'), 
(25, '178.26.16.59', '2021-09-30 18:39:37'), 
(0, '194.234.189.126', '2021-08-22 17:43:11'),
 (20, '163.29.165.120', '2021-04-4 22:55:52'),
 (30, '97.0.127.186', '2021-04-1 15:28:02'), 
(19, '194.234.189.126', '2021-05-7 9:20:50'), 
(5, '57.193.133.133', '2021-08-1 15:56:01'), 
(0, '52.231.122.64', '2021-07-25 18:53:28'), 
(0, '213.127.38.238', '2021-08-3 19:31:56'), 
(26, '225.133.53.175', '2021-03-23 2:21:41'),
 (0, '175.119.240.52', '2021-10-10 17:19:23'), 
(25, '216.10.177.66', '2021-02-3 12:53:34'), 
(3, '113.247.142.205', '2021-06-28 20:31:19'), 
(0, '82.27.1.94', '2021-01-25 23:59:43'), 
(26, '202.129.109.184', '2021-03-18 11:17:10'),
 (5, '129.42.187.115', '2021-03-22 8:38:15'), 
(2, '181.138.231.193', '2021-02-14 10:50:09'), 
(0, '163.29.165.120', '2021-05-21 1:07:19'),
 (0, '223.196.139.248', '2021-07-18 5:05:43'),
 (15, '52.73.250.35', '2021-03-23 20:09:02'), 
(19, '52.231.122.64', '2021-05-13 16:57:30'), 
(11, '213.127.38.238', '2021-02-17 10:30:51'),
 (21, '179.74.82.88', '2021-05-19 1:32:01'), 
(18, '148.26.108.236', '2021-03-28 19:37:06'), 
(12, '179.74.82.88', '2021-11-25 17:02:01');
SELECT * FROM requests;

Records: 60  Duplicates: 0  Warnings: 0

id	user_id	ip	at
1	0	28.249.36.119	2021-05-23 23:11:12
2	0	213.127.38.238	2021-09-23 08:45:08
3	18	28.249.36.119	2021-07-24 01:33:55
4	0	138.217.106.9	2021-09-21 22:30:13
5	0	175.119.240.52	2021-03-12 11:34:45
6	0	120.81.241.239	2021-04-08 01:55:34
7	0	28.249.36.119	2021-05-30 07:17:20
8	18	223.196.139.248	2021-09-11 05:38:29
9	27	205.206.101.128	2021-08-06 08:24:12
10	26	120.81.241.239	2021-05-28 17:35:04
11	0	178.26.16.59	2021-04-02 14:11:55
12	0	242.132.132.7	2021-11-22 19:48:59
13	2	113.247.142.205	2021-07-24 02:32:52
14	14	129.42.187.115	2021-05-13 14:13:17
15	18	241.224.51.109	2021-04-22 02:43:23
16	0	181.138.231.193	2021-09-21 10:56:02
17	18	202.129.109.184	2021-11-17 03:31:23
18	22	202.129.109.184	2021-03-18 11:29:57
19	26	52.231.122.64	2021-02-06 02:40:26
20	26	204.163.242.241	2021-08-20 10:34:56
21	24	223.196.139.248	2021-05-05 14:06:14
22	18	202.129.109.184	2021-10-10 09:56:27
23	0	213.127.38.238	2021-03-21 06:52:54
24	14	202.129.109.184	2021-09-07 05:54:54
25	25	77.132.236.152	2021-05-28 10:37:45
26	30	97.0.127.186	2021-03-04 14:56:36
27	25	163.29.165.120	2021-10-07 19:38:39
28	8	216.179.174.135	2021-05-27 09:04:07
29	25	205.206.101.128	2021-07-16 06:43:04
30	1	57.193.133.133	2021-07-05 20:11:38
31	13	52.73.250.35	2021-02-12 11:31:40
32	2	225.133.53.175	2021-01-29 05:19:57
33	0	94.52.178.105	2021-08-10 14:56:01
34	26	213.127.38.238	2021-07-06 14:29:53
35	0	133.205.168.233	2021-06-08 13:13:08
36	0	213.127.38.238	2021-09-11 01:29:38
37	25	178.26.16.59	2021-09-30 18:39:37
38	0	194.234.189.126	2021-08-22 17:43:11
39	20	163.29.165.120	2021-04-04 22:55:52
40	30	97.0.127.186	2021-04-01 15:28:02
41	19	194.234.189.126	2021-05-07 09:20:50
42	5	57.193.133.133	2021-08-01 15:56:01
43	0	52.231.122.64	2021-07-25 18:53:28
44	0	213.127.38.238	2021-08-03 19:31:56
45	26	225.133.53.175	2021-03-23 02:21:41
46	0	175.119.240.52	2021-10-10 17:19:23
47	25	216.10.177.66	2021-02-03 12:53:34
48	3	113.247.142.205	2021-06-28 20:31:19
49	0	82.27.1.94	2021-01-25 23:59:43
50	26	202.129.109.184	2021-03-18 11:17:10
51	5	129.42.187.115	2021-03-22 08:38:15
52	2	181.138.231.193	2021-02-14 10:50:09
53	0	163.29.165.120	2021-05-21 01:07:19
54	0	223.196.139.248	2021-07-18 05:05:43
55	15	52.73.250.35	2021-03-23 20:09:02
56	19	52.231.122.64	2021-05-13 16:57:30
57	11	213.127.38.238	2021-02-17 10:30:51
58	21	179.74.82.88	2021-05-19 01:32:01
59	18	148.26.108.236	2021-03-28 19:37:06
60	12	179.74.82.88	2021-11-25 17:02:01

date	count_new_users
2021.01	2
2021.02	5
2021.03	5
2021.04	4
2021.05	6
2021.06	2
2021.07	2
2021.08	2
2021.09	1
2021.10	0
2021.11	1
2021.12	0