使用SQL把单列转成多列

需要把图1的数据样式转换为图2的样式

SQL语法

图1 SQL：
SELECT area, code, class, val FROM table1

修改后

图2 SQL：
SELECT
max(case when class=‘进口总额’ then class END) as class1,
max(case when class=‘进口总额’ then val END) as val1,
max(case when class=‘固定资产投资额’ then class END) as class2,
max(case when class=‘固定资产投资额’ then val END) as val2,
max(case when class=‘出口总额’ then class END) as class3,
max(case when class=‘出口总额’ then val END) as val3
FROM
table1
GROUP BY area, code