7:27 4 K All Inboxes Lab 3.9 3.9 LAB - Select jESsoN schedule with inner join The database has three tables for tracking horse- riding lessons: 1. Horse with columns: o ID - primary key o...

Extracted text: 7:27 4 K All Inboxes Lab 3.9 3.9 LAB - Select jESsoN schedule with inner join The database has three tables for tracking horse- riding lessons: 1. Horse with columns: o ID - primary key o RegisteredName о Breed о Height o BirthDate 2. Student with columns: o ID - primary key o FirstName o LastName o Street o City o State o Zip o Phone o EmailAddress 3. LessonSchedule with columns: o HorselD - partial primary key, foreign key references Horse(ID) o StudentID - foreign key references Student(ID) o LessonDate Time - partial primary key Write a SELECT statement to create a lesson schedule with the lesson date/time, horse ID, and the student's first and last names. Order the results in ascendina order by lesson date/time then hu