I appreciate the use of diagrams to show the joins.

Do you want to add Instructor EID/UIN and Instruction Type is NULL for 2918 records.

If filtering to CCYYS >=20169, the NULLs will be 0.