Quato.sql

SET @r1=0, @r2=0, @r3=0, @r4=0;
SELECT MIN(Doctor), MIN(Professor), MIN(Singer), MIN(Actor)
FROM(
  SELECT 
    CASE 
        WHEN Occupation="Doctor" THEN (@r1:=@r1+1)
        WHEN Occupation="Professor" THEN (@r2:=@r2+1)
        WHEN Occupation="Singer" THEN (@r3:=@r3+1)
        WHEN Occupation="Actor" THEN (@r4:=@r4+1) 
    END AS RowNumber,
    CASE WHEN Occupation="Doctor" THEN Name END AS Doctor,
    CASE WHEN Occupation="Professor" THEN Name END AS Professor,
    CASE WHEN Occupation="Singer" THEN Name END AS Singer,
    CASE WHEN Occupation="Actor" THEN Name END AS Actor
  FROM OCCUPATIONS
  order by Name
    ) temp
group by RowNumber;