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_Occupations AS (
SELECT
Name ,
Occupation ,
ROW_NUMBER() OVER (PARTITION BY Occupation ORDER BY Name) AS RowNumber
FROM OCCUPATIONS
)
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 CTE_Occupations
GROUP BY RowNumber
ORDER BY RowNumber ;
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
Game of Stones
You are viewing a single comment's thread. Return to all comments →
WITH CTE_Occupations AS ( SELECT Name , Occupation , ROW_NUMBER() OVER (PARTITION BY Occupation ORDER BY Name) AS RowNumber FROM OCCUPATIONS ) 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 CTE_Occupations GROUP BY RowNumber ORDER BY RowNumber ;