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 ELSE NULL END) AS doctor,
MAX(CASE WHEN occupation = 'professor' THEN name ELSE NULL END) AS professor,
MAX(CASE WHEN occupation = 'singer' THEN name ELSE NULL END) AS singer,
MAX(CASE WHEN occupation = 'actor' THEN name ELSE NULL END) AS actor
FROM (
SELECT
name,
occupation,
ROW_NUMBER() OVER (PARTITION BY occupation ORDER BY name) AS rn
FROM occupations
) A
GROUP BY rn
ORDER BY rn;
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 ELSE NULL END) AS doctor, MAX(CASE WHEN occupation = 'professor' THEN name ELSE NULL END) AS professor, MAX(CASE WHEN occupation = 'singer' THEN name ELSE NULL END) AS singer, MAX(CASE WHEN occupation = 'actor' THEN name ELSE NULL END) AS actor FROM ( SELECT name, occupation, ROW_NUMBER() OVER (PARTITION BY occupation ORDER BY name) AS rn FROM occupations ) A GROUP BY rn ORDER BY rn;