Change select to

...
   LEFT JOIN addresses AS adr ;
    ON stu.student_id = adr.student_id ;
        AND stu.school_year = adr.school_year ;
   WHERE stu.enrollment_status <> 'INACTIVE' ;
...

>In the table, the field is in all caps. I am lazy when typing and didn't do the all caps in my question, but it is correct in the statement.