MySQL 8.0

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

CREATE TABLE  my_table (
  name varchar(25),
  terminal_id int,
  created_at date
);

insert into my_table values
('name1',91104,'2022-12-01'),
('name2',11161,'2022-12-02');

Records: 2  Duplicates: 0  Warnings: 0


select * from my_table;


name
terminal_id
created_at


name1
91104
2022-12-01

name2
11161
2022-12-02


select sum(terminal_id like '911%') as 911like,
       sum(terminal_id like '111%') as 111like
from my_table
where created_at between '2022-12-01' and '2022-12-10';


911like
111like


1
1