Pivot the Occupation column in OCCUPATIONS so that each Name is sorted alphabetically and displayed underneath its corresponding Occupation. The output should consist of four columns (Doctor, ...
OK, so I'm not sure this is even truly a bug, more just an annoying corner case. The problem is: when pivoting on multiple columns, the new column names are made from joining the pivot values with '_' ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results