Get row values only if a particular column's value does not exist
SELECT Studentnumber, name, DepartmentName
    FROM Student AS s
    WHERE NOT EXISTS (
            SELECT 1
                FROM Grade_Report
                WHERE Studentnumber = s.Studentnumber
                  AND Grade = 'A'
                     )