MySQL 8.0

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

-- Table1

CREATE TABLE Table1 (id INT,class varchar(10),amount varchar(50));

INSERT INTO Table1 (id,class,amount) 
VALUES
(1,'A',.25),
(1,'B',.25),
(1,'B',.25),
(1,'C',.25),
(1,'C',.25),
(1,'C',.25),
(2,'A',.25),
(2,'B',.25),
(2,'B',.25),
(2,'C',.25),
(2,'C',.25),
(2,'C',.25);


select * from Table1


id
class
amount


1
A
0.25

1
B
0.25

1
B
0.25

1
C
0.25

1
C
0.25

1
C
0.25

2
A
0.25

2
B
0.25

2
B
0.25

2
C
0.25

2
C
0.25

2
C
0.25


-- View1

CREATE OR REPLACE VIEW View1 AS

select id,

concat_ws(' / ',
concat_ws('','A:',(select  coalesce(SUM(amount),0)
from Table1
where class = 'A')),

concat_ws('','B:',(select  coalesce(SUM(amount),0)
from Table1
where class = 'B')),

concat_ws('','C:',(select  coalesce(SUM(amount),0)
from Table1
where class = 'C'))

) as totals
from Table1
group by id
select * from View1


id
totals


1
A:0.5 / B:1 / C:1.5

2
A:0.5 / B:1 / C:1.5

id	class	amount
1	A	0.25
1	B	0.25
1	B	0.25
1	C	0.25
1	C	0.25
1	C	0.25
2	A	0.25
2	B	0.25
2	B	0.25
2	C	0.25
2	C	0.25
2	C	0.25