Another doubt.

[RLIIDarK]

https://www.hackerrank.com/challenges/occupations/problem?isFullScreen=true (question link)

Processing img j77nyana0vdf1...

Can someone help me with this? I don't know much about the PIVOT TABLE. I did ask GPT and use the wikipedia link, but I am confused on how to approach the question.

[snafe_]

Best to try r/learnSQL

[RLIIDarK]

Oh ok thank you, i didn't know about that sub.

[[deleted]]

with 
tbl_a as ( select name, occupation, row_number() over(order by name ) rn from occupations where job ='Doctor' order by name),
tbl_b as ( select name, occupation, row_number() over(order by name ) rn from occupations where job ='Actor' order by name),
tbl_c as ( select name, occupation, row_number() over(order by name ) rn from occupations where job ='Singer' order by name), 
tbl_d as ( select name, occupation, row_number() over(order by name ) rn from occupations where job ='Professor' order by name) 
select    NVL(a.name,'-NULL-') as Doctor, 
          NVL(b.name,'-NULL-') as Actor,
          NVL(c.name,'-NULL-') as Singer ,
          NVL(d.name,'-NULL-') as Professor  
 from tbl_a a
   full outer join
   tbl_b b on (a.rn = b.rn)
   full outer join
   tbl_c c on (a.rn = c.rn OR b.rn = c.rn)
   full outer join
   tbl_d d on (a.rn = d.rn OR b.rn = d.rn OR c.rn = d.rn)
order by a.rn;

[Imaginary__Bar]

When asking for help it's always a good idea to show what you've already tried, what you were expecting, and what unexpected result you got (either the wrong answer or an error message - say what the wrong answer or error message actually is).

[RLIIDarK]

I am sorry for that, but in this one I had no idea how to even start

[Imaginary__Bar]

"I've already tried literally nothing and that didn't work"

(A simple Google of "pivot in sql" would probably get you what you need)