You are viewing a single comment's thread. Return to all comments →
with temp as ( select *, row_number() over(partition by occupation order by name) as indexing from occupations ) select min(if(occupation="Doctor",name, null)) as n1, min(if(occupation="Professor",name, null)) as n2, min(if(occupation="Singer",name, null)) as n3, min(if(occupation="Actor",name, null)) as n4 from temp group by indexing;
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 →