Write the SQL code for the following: Increase the balance by 2% of any patient whose balance

Question:

Write the SQL code for the following: Increase the balance by 2% of any patient whose balance is greater than $2,000.

a. UPDATE Patient SET Balance = Balance*1.2 WHERE Balance>2000;

b. UPDATE Patient SET Balance = Balance*1.02 WHERE Balance>2000;

c. UPDATE Patient SET Balance = Balance*2%

WHERE Balance>2000;

d. SELECT Patient SET Balance = Balance*1.02 WHERE Balance>2000;PatientNum LastName FirstName Koehler King Houghland Falls Odepaul Venable Waggoner 1010 1011 1012 1013. 1014

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: