What am I doing wrong with my SQL code?

SELECT LessonSchedule.LessonDateTime, Student.FirstName, Student.LastName, Horse.RegisteredName

FROM LessonSchedule

INNER JOIN Horse ON Horse.ID $=$ Horse.ID

INNER JOIN Student ON Student.ID $=$ STUDENT.id

ORDER BY LessonDateTime ASC, RegisteredName;