MySQL 8.0

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

CREATE TABLE mymodels (
  id INT AUTO_INCREMENT PRIMARY KEY,
  name_list VARCHAR(255),           -- поправлено
  title VARCHAR(255),
  count_model INT,
  created_at TIMESTAMP
  );
INSERT INTO mymodels (name_list, title, count_model,  created_at) VALUES
  ('00001_00001','Проверка 1', 2, NOW()),
  ('00001_00001','Проверка 1', 1, NOW()),
  ('00002_00002','Проверка 1', 3, NOW()),
  ('00002_00002','Проверка 1', 4, NOW()),
  ('00003_00003','Проверка 2', 1, NOW()),
  ('00003_00003','Проверка 2', 3, NOW());
SELECT * FROM mymodels;

Records: 6  Duplicates: 0  Warnings: 0




id
name_list
title
count_model
created_at


1
00001_00001
Проверка 1
2
2022-12-02 18:19:06

2
00001_00001
Проверка 1
1
2022-12-02 18:19:06

3
00002_00002
Проверка 1
3
2022-12-02 18:19:06

4
00002_00002
Проверка 1
4
2022-12-02 18:19:06

5
00003_00003
Проверка 2
1
2022-12-02 18:19:06

6
00003_00003
Проверка 2
3
2022-12-02 18:19:06


/*  требуемый результат
[
  {"title_list":"Проверка 1","count_model":3,"total":2,"date":"2022-12-02 14:08:07"},
  {"title_list":"Проверка 1","count_model":7,"total":2,"date":"2022-12-02 15:08:07"},
  {"title_list":"Проверка 2","count_model":4,"total":2,"date":"2022-12-02 16:08:07"}
]
*/
SELECT ANY_VALUE(title) AS title_list,
       SUM(count_model) count_model,
       COUNT(*) total,
       ANY_VALUE(created_at) `date`
FROM mymodels
GROUP BY name_list
ORDER BY name_list;


title_list
count_model
total
date


Проверка 1
3
2
2022-12-02 18:19:06

Проверка 1
7
2
2022-12-02 18:19:06

Проверка 2
4
2
2022-12-02 18:19:06

id	name_list	title	count_model	created_at
1	00001_00001	Проверка 1	2	2022-12-02 18:19:06
2	00001_00001	Проверка 1	1	2022-12-02 18:19:06
3	00002_00002	Проверка 1	3	2022-12-02 18:19:06
4	00002_00002	Проверка 1	4	2022-12-02 18:19:06
5	00003_00003	Проверка 2	1	2022-12-02 18:19:06
6	00003_00003	Проверка 2	3	2022-12-02 18:19:06