Leetcode 618. 学生地理信息报告（分组行转列）

select 
    min(case when continent='America' then name end) America,
    min(case when continent='Asia' then name end)Asia,
    min(case when continent='Europe' then name end)Europe
    from(
        select *,row_number() over(partition by continent order by name ) r
        from student
    )A
    group by r