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 ascending order by lesson date/time, then by horse ID. Unassigned lesson times should not appear in the schedule.

4.6 LAB – Select lesson schedule with inner join
The database has three tables for tracking horse-riding lessons:

Horse with columns:
ID – primary key
Registered Name
Breed
Height
Birth Date
Student with columns:
ID – primary key
First Name
LastName
Street
City
State
Zip
Phone
Email Address
Lesson Schedule with columns:
Horse ID – partial primary key, foreign key references Horse(ID)
Student ID – foreign key references Student(ID)
Lesson Date 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 ascending order by lesson date/time, then by horse ID. Unassigned lesson times should not appear in the schedule.

Hint: Perform a join on the Student and Lesson Schedule tables, matching the student IDs.

Last Completed Projects