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

FROM LessonSchedule

LEFT JOIN Horse ON LessonSchedule.HorseID $=$ Horse.ID

LEFT JOIN Student ON LessonSchedule.StudentID $=$ Student.ID

WHERE LessonSchedule.LessonDateTime $>=\text{'}2020-02-01\text{'}$ AND LessonSchedule.LessonDateTime

ORDER BY LessonSchedule.LessonDateTime ASC, Horse.RegisteredName ASC;$3\mathrm{.}14$ LAB $-$ Select lesson schedule with multiple joins

The database has three tables for tracking horse$-$riding lessons:

Horse with columns:

ID $-$ primary key

RegisteredName

Breed

Height

BirthDate

Student with columns:

ID $-$ primary key

FirstName

LastName

Street

City

State

Zip

Phone

EmailAddress

LessonSchedule with columns:

HorselD $-$ partial primary key, foreign key references Horse$($ID$)$

StudentID $-$ foreign key references Student$($ID$)$

LessonDateTime $-$ partial primary key

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.

$521766\mathrm{.}2891978.$q$3$zqy$?$