DAT/380 Week 4 LAB 4.6 - Select lesson schedule with inner join

Availability: In stock

Regular Price: $5.00

Special Price: $3.00

OR

DAT380 Week 4 LAB 4.6 - Select lesson schedule with inner join

Double click on above image to view full picture

Zoom Out
Zoom In

More Views

Quick Overview

DAT/380 Week 4 LAB 4.6 - 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.

Regular Price: $5.00

Special Price: $3.00

Details

DAT/380 Week 4 LAB 4.6 - 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.

Additional Information

Special Price $3.00

Product Tags

Use spaces to separate tags. Use single quotes (') for phrases.