= 'true'
),
HR AS (
SELECT SH.studentPersonID, SH.teacherDisplay
FROM v_StudentHomeroom SH
JOIN Trial T ON ... l AS guardian2Email,
PI.inputData AS lunchPin,
HR.teacherDisplay AS homeRoom
FROM S
LEFT JOIN RP RP1 ON S.p... S.personID
WHERE grade IN('06','07','08') AND HR.teacherDisplay IS NULL
</code>
===== Staff =====
<code s