3.9 LAB - Select lesson schedule with inner join

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:

HorseID - 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 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 (student ID is NULL) should not appear in the schedule.

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

3.9 LAB - Select lesson schedule with inner join The database has three tables for tracking horse-riding lessons: 1. Horse with columns: ID - primary key RegisteredName Breed Height BirthDate 2. Student with columns: - ID - primary key - FirstName - LastName - Street - City - State Zip Phone EmailAddress 3. 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 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 (student ID is NULL) should not appear in the schedule. Hint: Perform a join on the Student and LessonSchedule tables, matching the student IDs