We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
with cte as (
select *, row_number()over(partition by occupation order by name ) row_num from occupations)
select min(case when occupation = "doctor" then name else null end),
min(case when occupation = "Professor" then name else null end),
min(case when occupation = "Singer" then name else null end),
min(case when occupation = "Actor" then name else null end)
from cte
group by row_num
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
Occupations
You are viewing a single comment's thread. Return to all comments →
with cte as ( select *, row_number()over(partition by occupation order by name ) row_num from occupations) select min(case when occupation = "doctor" then name else null end), min(case when occupation = "Professor" then name else null end), min(case when occupation = "Singer" then name else null end), min(case when occupation = "Actor" then name else null end)
from cte group by row_num