Leetcode SQL (#618 – #620)

select 
m1.name as America, 
m2.name as Asia, 
m3.name as Europe
from (
    select 
    name, 
    row_number() over(order by name) as r
    from student
    where continent = 'America'
) m1
left join (
    select 
    name, 
    row_number() over(order by name) as r
    from student
    where continent = 'Asia'
) m2 
    on m1.r = m2.r
left join (
    select 
    name, 
    row_number() over(order by name) as r
    from student
    where continent = 'Europe'
) m3 
    on m1.r = m3.r

select 
max(num) as num
from(
    select 
    num, 
    count(*) over(partition by num) as r
    from my_numbers
) n
where r = 1

select *
from cinema
where description <> 'boring'
and mod(id,2) = 1
order by rating desc