Write the SQL code for the following: Update all class prices to reflect a 1% increase. a.

Question:

Write the SQL code for the following: Update all class prices to reflect a 1% increase.

a. UPDATE Reservations SET ClassPrice = ClassPrice*1.10;

b. UPDATE Reservations SET ClassPrice = ClassPrice*1%;

c. UPDATE Reservations SET ClassPrice = ClassPrice*0.1;

d. UPDATE Reservations SET ClassPrice = ClassPrice*1.01;InstructoriD InstructorLastName InstructorFirstName InstructorStreetAddress InstructorCity 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: