Write the SQL code for the following: List the full name of the therapist scheduled to work

Question:

Write the SQL code for the following: List the full name of the therapist scheduled to work on 10/16/2021.

a. SELECT Therapist.FirstName, Therapist.LastName FROM Therapist WHERE Therapist.TherapistID = Session.TherapistID AND SessionDate = #10/16/2021#;

b. SELECT Therapist.FirstName, Therapist.LastName FROM Session WHERE Therapist.TherapistID = Session.TherapistID AND SessionDate = #10/16/2021#;

c. SELECT Therapist.FirstName, Therapist.LastName FROM Therapist, Session WHERE Therapist.TherapistID = Session.TherapistID;

d. SELECT Therapist.FirstName, Therapist.LastName FROM Therapist, Session WHERE Therapist.TherapistID = Session.TherapistID AND SessionDate = #10/16/2021#;PatientNum LastName FirstName Koehler King Houghland Falls Odepaul Venable Waggoner 1010 1011 1012 1013. 1014

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Concepts Of Database Management

ISBN: 9780357422083

10th Edition

Authors: Lisa Friedrichsen, Lisa Ruffolo, Ellen Monk, Joy L. Starks, Philip J. Pratt

Question Posted: