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.
The database has three tables for tracking horse-riding lessons: Horse with columns: Student with columns: LessonSchedul
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
The database has three tables for tracking horse-riding lessons: Horse with columns: Student with columns: LessonSchedul
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!