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';

Transcribed Image Text:

PatientNum LastName FirstName Koehler King Houghland Falls Odepaul Venable Waggoner 1010 1011 1012 1013. 1014 1015 1016 1017 1018 1019 1020 1021 Short Baptist Culling Marino Wilson Robbie Joseph Susan Tierra Ben Isaiah Brianna Tobey Joseph Latisha Andre Tammy Address 119 West Bay Dr. 941 Treemont 7841 Lake Side Dr. 44 Applewood Ave. 546 WCR 150 South 37 High School Road 2691 Westgrove St. 1928 10th Ave. 300 Erin Dr. 4238 East 71st St. 919 Horton Ave. 424 October Blvd. State ZipCode City San Vista TX 72510 TX 74081 Oak Hills Munster 72380 72511 TX Palm Rivers TX Munster Waterville TX 74093 TX 74183 Delbert TX 72381 Munster TX 72512 TX 76658 Waterville San Vista TX 74071 Georgetown TX 72379 Waterville TX 76658 Balance $1,535.15 $212.80 $1,955.40 $1,000.35 $525.00 $432.30 $714.25 $967.60 $1,846.75 $1,988.50 $688.95 $2,015.30