The database has three tables for tracking horse-riding lessons: Horse with columns: Student with columns: LessonSchedul
Posted: Thu Jul 14, 2022 2:12 pm
The database has three tables for tracking horse-ridinglessons:
Horse with columns:
Student with columns:
LessonSchedule with columns:
Write a SELECT statement to create a lesson schedule for Feb 1,2020 with the lesson date/time, student's first and last names, andthe horse's registered name. Order the results in ascending orderby lesson date/time, then by the horse's registered name. Make sureunassigned lesson times (student ID is NULL) appear in theresults.
Hint: Perform a join on the LessonSchedule, Student, and Horsetables, matching the student IDs and horse IDs.
Horse with columns:
Student with columns:
LessonSchedule with columns:
Write a SELECT statement to create a lesson schedule for Feb 1,2020 with the lesson date/time, student's first and last names, andthe horse's registered name. Order the results in ascending orderby lesson date/time, then by the horse's registered name. Make sureunassigned lesson times (student ID is NULL) appear in theresults.
Hint: Perform a join on the LessonSchedule, Student, and Horsetables, matching the student IDs and horse IDs.