Module 3 Sports Physical Therapy case

docx

School

St. Petersburg College *

*We aren’t endorsed by this school

Course

MISC

Subject

Mechanical Engineering

Date

Dec 6, 2023

Type

docx

Pages

1

Uploaded by Cyakt1

Report
ISM3212 Module 3 Sports Physical Therapy case 1. Write an SQL query that displays the therapies and their unit of time for the therapies that include the word bath, hot, or electrical. SELECT Therapy, UnitOfTime: This selects the "Therapy" and "UnitOfTime" columns from the "Therapies" table. FROM Therapies: This specifies the table from which to retrieve data (assuming the table is named "Therapies"). WHERE Therapy LIKE '%bath%' OR Therapy LIKE '%hot%' OR Therapy LIKE '%electrical': This filter condition selects rows where the "Therapy" column contains the words "bath," "hot," or "electrical" anywhere in the text. 2. Write an SQL query to display every therapist’s first name and last name as their full name, but only for those instructors not living in zip code 72511. SELECT CONCAT(FirstName, ' ', LastName) AS FullName: This selects the first name and last name concatenated as "FullName." The CONCAT function combines the first name and last name with a space in between to form the full name. FROM Therapists: This specifies the table from which to retrieve the data (assuming the table is named "Therapists"). WHERE ZipCode <> '72511': This filter condition ensures that only therapists with a zip code different from '72511' are included in the result. The query will return the full names of therapists who do not live in zip code 72511.
Discover more documents: Sign up today!
Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help