MySQL 8.0

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

CREATE TABLE test (id INT, type INT);
INSERT INTO test VALUES
(1,2),
(2,3),
(3,4),
(4,1),
(5,5),
(6,1),
(7,1),
(8,2),
(9,3),
(10,4),
(11,5),
(12,1),
(13,2),
(14,5),
(15,3);
CREATE TABLE fruits (type INT, name VARCHAR(64));
INSERT INTO fruits VALUES
(1, 'яблоко'), (2, 'груша'), (3, 'манго'), (4, 'банан'), (5, 'апельсин');

Records: 15  Duplicates: 0  Warnings: 0



Records: 5  Duplicates: 0  Warnings: 0


WITH cte AS (SELECT type, COUNT(id) `count` FROM test GROUP BY type)
SELECT type, `count`, CONCAT(100 * `count` / SUM(`count`) OVER ()) percent
FROM cte;


type
count
percent


2
3
20.0000

3
3
20.0000

4
2
13.3333

1
4
26.6667

5
3
20.0000


WITH cte AS ( SELECT type, 
                     COUNT(id) amount 
              FROM test 
              GROUP BY type )
SELECT cte.type, 
       fruits.name,
       cte.amount, 
       CONCAT(100 * cte.amount / SUM(cte.amount) OVER ()) percent
FROM cte
JOIN fruits USING (type);


type
name
amount
percent


1
яблоко
4
26.6667

2
груша
3
20.0000

3
манго
3
20.0000

4
банан
2
13.3333

5
апельсин
3
20.0000

type	name	amount	percent
1	яблоко	4	26.6667
2	груша	3	20.0000
3	манго	3	20.0000
4	банан	2	13.3333
5	апельсин	3	20.0000