Write the SQL code that answers the following question: How long are the therapy sessions for the
Question:
Write the SQL code that answers the following question: How long are the therapy sessions for the therapist whose last name is Shields? List the length of each session.
a. SELECT Session.LengthOfSession, Therapist.LastName='Shields'
FROM Therapist, Session WHERE Therapist.TherapistID = Session.TherapistID;
b. SELECT Session.LengthOfSession FROM Therapist, Session WHERE Therapist.LastName='Shields';
c. SELECT Session.LengthOfSession FROM Therapist, Session WHERE Therapist.TherapistID = Session.TherapistID AND Therapist.
LastName='Shields';
d. SELECT Session.LengthOfSession FROM Session WHERE Therapist.TherapistID = Session.TherapistID AND Therapist.
LastName='Shields';
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