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

The Horse table has columns:

ID $-$ primary key

RegisteredName

Breed

Height

BirthDate

The Student table has columns:

ID $-$ primary key

FirstName

LastName

Street

City

State

Zip

Phone

EmailAddress

The LessonSchedule table has columns:

HorseID $-$ foreign key references Horse

StudentID $-$ foreign key references Student

LessonDateTime $-$ datetime

Primary key is $($HorseID$,$ LessonDateTime$)$

To produce a list of available lesson times, write a statement that selects lesson datetime, horse ID$,$ and the student's first and last name. Order the results in ascending order by lesson datetime, then by horse ID$.$ Display unassigned lesson times $($student ID is NULL$)$ in the results.

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