MySQL 8.0

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

create table test (domain varchar(64), c int);
insert into test values
('gmail','12'),
('dddd','2'),   
('mmmmm','2'),   
('dsf','2'),   
('aaaa','1'),   
('bbbb','1'),   
('ccc','1'),   
('yopmail','1'),   
('yahoo','1'),   
('dde','1'),   
('rfg','1'),   
('eedd','1'),   
('dfdg','1'),   
('sad','1'),   
('dfdf','1'),   
('sfd','1'),   
('web','1');   
WITH cte AS (
     SELECT * FROM test ORDER BY c DESC
)
SELECT 
     IF(rn < 10, domain, 'others') AS domain_name,
     SUM(c) AS count
FROM (
     SELECT domain, c, ROW_NUMBER() OVER () AS rn FROM cte
) T
GROUP BY domain_name


domain_name
count


gmail
12

dddd
2

mmmmm
2

dsf
2

web
1

sfd
1

dfdf
1

sad
1

dfdg
1

others
8