Referencing label from Select clause in where, simple sql query
"Aggregates" cannot be referenced in WHERE.  But they can be moved to HAVING:

SELECT  student.name, MAX(grades.final_grade) as max_grade
    From  grades , students
    where  student.id = grade.student_id
    HAVING  max_grade = 90


Also it is =, not ==.