Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

12.13 LAB - Select lesson schedule with multiple joins

Hello, I need help on this sql query statement.

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.

This is my database...

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