CREATE TABLE TableA(
month varchar(20),	
useMins int(20),	
sumCase int(20),	
sumPer int(20),
sumChat int(20),
sumRating int(20)
);

INSERT INTO TableA (month,useMins,sumCase,sumPer,sumChat,sumRating)
VALUES 
('6',42,38,2,200,798),
('7',0,7,1,2,5);

SELECT name,
SUM(CASE WHEN month='1' THEN amount ELSE 0 END) AS '01',
SUM(CASE WHEN month='2' THEN amount ELSE 0 END) AS '02',
SUM(CASE WHEN month='3' THEN amount ELSE 0 END) AS '03',
SUM(CASE WHEN month='4' THEN amount ELSE 0 END) AS '04',
SUM(CASE WHEN month='5' THEN amount ELSE 0 END) AS '05',
SUM(CASE WHEN month='6' THEN amount ELSE 0 END) AS '06',
SUM(CASE WHEN month='7' THEN amount ELSE 0 END) AS '07',
SUM(CASE WHEN month='8' THEN amount ELSE 0 END) AS '08',
SUM(CASE WHEN month='9' THEN amount ELSE 0 END) AS '09',
SUM(CASE WHEN month='10' THEN amount ELSE 0 END) AS '10',
SUM(CASE WHEN month='11' THEN amount ELSE 0 END) AS '11',
SUM(CASE WHEN month='12' THEN amount ELSE 0 END) AS '12'
FROM (
SELECT month,'useMins' AS name,useMins AS amount
FROM TableA 
UNION ALL 
SELECT month,'sumCase' AS name,sumCase AS amount
FROM TableA 
UNION ALL
SELECT month,'sumPer' AS name,sumPer AS amount
FROM TableA 
UNION ALL
SELECT month,'sumChat' AS name,sumChat AS amount
FROM TableA 
UNION ALL
SELECT month,'sumRating' AS name,sumRating AS amount
FROM TableA 
) AS Z
GROUP BY name
ORDER BY CASE WHEN name='useMins' THEN 1 
WHEN name='sumCase' THEN 2
WHEN name='sumPer' THEN 3
WHEN name='sumChat' THEN 4 
WHEN name='sumRating' THEN 5 ELSE 10 END

Demo

因為併入了七個table還包含了left join 寫進的暫時table

早說嗎，怎麼你不早說

我資料都做好了

db fiddle

這題我不會，純提供測試資料給真正高手