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
COALESCE(MAX(CASE WHEN occupation = 'Doctor' THEN name END), 'NULL'),
COALESCE(MAX(CASE WHEN occupation = 'Professor' THEN name END), 'NULL'),
COALESCE(MAX(CASE WHEN occupation = 'Singer' THEN name END), 'NULL'),
COALESCE(MAX(CASE WHEN occupation = 'Actor' THEN name END), 'NULL')
FROM (
SELECT
name,
occupation,
ROW_NUMBER() OVER (PARTITION BY occupation ORDER BY name) rn
FROM OCCUPATIONS
) t
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 COALESCE(MAX(CASE WHEN occupation = 'Doctor' THEN name END), 'NULL'), COALESCE(MAX(CASE WHEN occupation = 'Professor' THEN name END), 'NULL'), COALESCE(MAX(CASE WHEN occupation = 'Singer' THEN name END), 'NULL'), COALESCE(MAX(CASE WHEN occupation = 'Actor' THEN name END), 'NULL') FROM ( SELECT name, occupation, ROW_NUMBER() OVER (PARTITION BY occupation ORDER BY name) rn FROM OCCUPATIONS ) t GROUP BY rn ORDER BY rn;