To generate a schedule list, create a view in SQL that shows the session date and the
Question:
To generate a schedule list, create a view in SQL that shows the session date and the last name and first name of the therapist. Show the list in chronological order.
a. SELECT Session.SessionDate, Therapist.LastName, Therapist.FirstName FROM Therapist INNER JOIN [Session] ON Therapist.TherapistID = Session.
TherapistID ORDER BY Session.SessionDate;
b. SELECT Session.SessionDate, Therapist.LastName, Therapist.FirstName FROM Therapist INNER JOIN [Session] ON Therapist.TherapistID = Session.
TherapistID DISPLAY BY Session.SessionDate;
c. SELECT Session.SessionDate, Therapist.LastName, Therapist.FirstName FROM Therapist ORDER BY Session.SessionDate;
d. SELECT Session.SessionDate, Therapist.LastName, Therapist.FirstName FROM Therapist INNER JOIN [Session] ON Therapist.TherapistID = Session.
TherapistID ORDER BY Date;
Step by Step Answer:
Concepts Of Database Management
ISBN: 9780357422083
10th Edition
Authors: Lisa Friedrichsen, Lisa Ruffolo, Ellen Monk, Joy L. Starks, Philip J. Pratt