Write a SELECT statement to create a lesson schedule for Feb $1,2020$ with the lesson date$/$time$,$ student's first and last names, and the horse's registered name. Order the results in ascending order by lesson date$/$time$,$ then by the horse's registered name. Make sure unassigned lesson times $($student ID is NULL$)$ appear in the results.

Hint: Perform a join on the LessonSchedule, Student, and Horse tables, matching the student IDs and horse IDs.