When executing the query with adding the FULL JOIN with where clause like below -

SELECT Professor.Id AS [Professor.Id], Professor.ProfessorName,

CASE Professor.HasTenure WHEN 1 THEN...