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

Transcribed Image Text:

InstructoriD InstructorLastName InstructorFirstName InstructorStreetAddress Instructor City InstructorState InstructorZipCode InstructorEmail Address Pittsburgh Pittsburgh Pittsburgh Pittsburgh Pittsburgh Pittsburgh Pittsburgh Pittsburgh Pittsburgh Pittsburgh JV01 LL01 MA01 MD01 MK01 MS01 NT01 RS01 RS02 VP01 Varlano Lane Nguyen D'Angelo Kobinski Said Tahan Stein Sisto Pegues Juan Luke Michael Maria Megan Memo Neda Raymond Robert Vicki 15A Penn Ave 2661 Butler St 2367 Barn Way 245D Wylle Ave 9087 Monanca Pl 45 Webster Ave 4588 Penn Ave 3254 Forward Ave 2836 Maryland Ave 3700 Murray Ave PA PA PA PA PA PA PA PA PA PA 15219 15201 15219 15219 15219 15219 15219 15217 15232 15217 InstructorPhoneNumber Juan Varlano@cengage.com 412-998-6534 561-868-5257 MichaelNguyen@cengage.com | 951-790-6275 LukeCLane@cengage.com MariaDAngelo@cengage.com 724-887-2835 MeganKobinski@cengage.com 878-653-7364 412-764-9834 417-359-2241 RaymondStein@cengage.com 269-345-0803 RobertJSisto@cengage.com 646-373-8125 VickiJPegues@cengage.com 678-597-0247 MemoSaid@cengage.com NedaTahan@cengage.com