Write the SQL code to create a view for Pitt Fitness that displays all the classes held

Question:

Write the SQL code to create a view for Pitt Fitness that displays all the classes held at the Downtown location.

Show only the fields ClassName, Room, Day, Time, and Description. Show the ClassName field as Class Name.

a. SELECT ClassName AS [Class Name], Room, Day, Time, Description FROM Classes WHERE Location=”Downtown”;

b. SELECT Class Name, Room, Day, Time, Description FROM Classes WHERE Location=”Downtown”;

c. SELECT ClassName, Room, Day, Time, Description WHERE Location=”Downtown”;

d. SELECT ClassName, Room, Day, Time, Description FROM Classes WHERE NOT Location=”Downtown”;InstructoriD InstructorLastName InstructorFirstName InstructorStreetAddress Instructor City InstructorState

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: