3.8 LAB – Select lesson schedule with multiple joins The database has three tabl

    3.8 LAB – Select lesson schedule with multiple joins
    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 for Feb 1, 2020 with the lesson date/time, student’s first and last names, and the horse’s registered name. Order the results in ascending order by lesson date/time, then by the horse’s registered name. Make sure unassigned lesson times (student ID is NULL) appear in the results.
    Hint: Perform a join on the LessonSchedule, Student, and Horse tables, matching the student IDs and horse IDs.

    Leave a Reply

    Your email address will not be published. Required fields are marked *