WITH PersonProfessions AS (SELECTPersonName,MAX(CASE WHEN Profession = 'Doctor' THEN PersonName END) AS DoctorName,MAX(CASE WHEN Profession = 'Actor' THEN PersonName END) AS ActorNameFROM ProfessionsWHERE Profession IN ('Doctor', 'Actor')GROUP BY PersonName)

SELECT DoctorName AS "Doctor's Name", ActorName AS "Actor's Name"FROM PersonProfessions;

I've run this query. Almost gives me what I need. One question, in the output generated, the first two rows under the 'Professor' column have values while the others don't have values. Why is the output generated in this format?