618. 学生地理信息报告

618. 学生地理信息报告

select  max(case when continent ='America' then name else null end) America,
        max(case when continent ='Asia' then name else null end) Asia,
        max(case when continent ='Europe' then name else null end) Europe
        from(
            select name,continent,
            row_number()over(partition by continent order by name ) paiming
            from student)new_table
group by paiming