LeetCode MySQL 618. 学生地理信息报告（row_number）

| name   | continent |
|--------|-----------|
| Jack   | America   |
| Pascal | Europe    |
| Xi     | Asia      |
| Jane   | America   |

| America | Asia | Europe |
|---------|------|--------|
| Jack    | Xi   | Pascal |
| Jane    |      |        |

(
    select name, row_number() over(order by name) rnk
    from student
    where continent='America'
)

{"headers": ["name", "rnk"], "values": [["Jack", 1], ["Jane", 2]]}

# Write your MySQL query statement below
select America, Asia, Europe
from
(
    select name America, row_number() over(order by name) rnk
    from student
    where continent='America'
) a
left join
(
    select name Asia, row_number() over(order by name) rnk
    from student
    where continent='Asia'
) b
using(rnk)
left join 
(
    select name Europe, row_number() over(order by name) rnk
    from student
    where continent='Europe'
) c
using(rnk)