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.
SELECT
MAX(CASE WHEN occupation = 'Doctor' THEN Name END) AS Doctor,
MAX(CASE WHEN occupation = 'Professor' THEN Name END) AS Professor,
MAX(CASE WHEN occupation = 'Singer' THEN Name END) AS Singer,
MAX(CASE WHEN occupation = 'Actor' THEN Name END) AS Actor
FROM
(SELECT occupation, Name, ROW_NUMBER() OVER (PARTITION BY occupation ORDER BY Name) AS rnk
FROM OCCUPATIONS) AS ranked
GROUP BY
rnk
ORDER BY
rnk;
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 →
SELECT MAX(CASE WHEN occupation = 'Doctor' THEN Name END) AS Doctor, MAX(CASE WHEN occupation = 'Professor' THEN Name END) AS Professor, MAX(CASE WHEN occupation = 'Singer' THEN Name END) AS Singer, MAX(CASE WHEN occupation = 'Actor' THEN Name END) AS Actor FROM (SELECT occupation, Name, ROW_NUMBER() OVER (PARTITION BY occupation ORDER BY Name) AS rnk FROM OCCUPATIONS) AS ranked GROUP BY rnk ORDER BY rnk;