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 – […]