Tag: null-handling
All the articles with the tag "null-handling".
Your WHERE <> filter is silently dropping every NULL row
WHERE role <> 'TA' looks like it means everyone who isn't a TA. It means everyone we know for certain isn't a TA. Nothing errors, the result is just short.