MySQL 8.0

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

CREATE TABLE temp
(created_date TIMESTAMP,
services_name VARCHAR(10),
id INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY (id)
);
INSERT INTO temp (created_date, services_name)
VALUES
('2022-08-28 18:54','KANE'),
('2022-08-28 19:00','BAPLO'),
('2022-08-28 23:22','BAPLO'),
('2022-08-28 23:40','VLOTLS'),
('2022-08-29 00:02','DELLP'),
('2022-08-29 00:42','SECON'),
('2022-08-29 02:00','BAPLO'),
('2022-08-29 03:00','PRODC'),
('2022-08-29 05:14','DELLP'),
('2022-08-29 05:30','SECON'),
('2022-08-29 05:42','SECON');
SELECT *, time(created_date) as time_frame FROM temp


created_date
services_name
id
time_frame


2022-08-28 18:54:00
KANE
1
18:54:00

2022-08-28 19:00:00
BAPLO
2
19:00:00

2022-08-28 23:22:00
BAPLO
3
23:22:00

2022-08-28 23:40:00
VLOTLS
4
23:40:00

2022-08-29 00:02:00
DELLP
5
00:02:00

2022-08-29 00:42:00
SECON
6
00:42:00

2022-08-29 02:00:00
BAPLO
7
02:00:00

2022-08-29 03:00:00
PRODC
8
03:00:00

2022-08-29 05:14:00
DELLP
9
05:14:00

2022-08-29 05:30:00
SECON
10
05:30:00

2022-08-29 05:42:00
SECON
11
05:42:00


SELECT 'Morning' as time_frame, COUNT(*) AS `count` FROM temp 
         WHERE TIME(created_date)  
         BETWEEN '07:30:00' AND '19:30:00'
UNION
SELECT 'Evening' as time_frame, COUNT(*) AS `count` FROM temp 
         WHERE TIME(created_date)  
         NOT BETWEEN '07:30:00' AND '19:30:00'


time_frame
count


Morning
2

Evening
9

`created_date`	`services_name`	`id`	`time_frame`
`2022-08-28 18:54:00`	`KANE`	`1`	`18:54:00`
`2022-08-28 19:00:00`	`BAPLO`	`2`	`19:00:00`
`2022-08-28 23:22:00`	`BAPLO`	`3`	`23:22:00`
`2022-08-28 23:40:00`	`VLOTLS`	`4`	`23:40:00`
`2022-08-29 00:02:00`	`DELLP`	`5`	`00:02:00`
`2022-08-29 00:42:00`	`SECON`	`6`	`00:42:00`
`2022-08-29 02:00:00`	`BAPLO`	`7`	`02:00:00`
`2022-08-29 03:00:00`	`PRODC`	`8`	`03:00:00`
`2022-08-29 05:14:00`	`DELLP`	`9`	`05:14:00`
`2022-08-29 05:30:00`	`SECON`	`10`	`05:30:00`
`2022-08-29 05:42:00`	`SECON`	`11`	`05:42:00`

`time_frame`	`count`
`Morning`	`2`
`Evening`	`9`