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;

Transcribed Image Text:

PatientNum LastName FirstName Koehler King Houghland Falls Odepaul Venable Waggoner 1010 1011 1012 1013. 1014 1015 1016 1017 1018 1019 1020 1021 Short Baptist Culling Marino Wilson Robbie Joseph Susan Tierra Ben Isaiah Brianna Tobey Joseph Latisha Andre Tammy Address 119 West Bay Dr. 941 Treemont 7841 Lake Side Dr. 44 Applewood Ave. 546 WCR 150 South 37 High School Road 2691 Westgrove St. 1928 10th Ave. 300 Erin Dr. 4238 East 71st St. 919 Horton Ave. 424 October Blvd. State ZipCode City San Vista TX 72510 TX 74081 Oak Hills Munster 72380 72511 TX Palm Rivers TX Munster Waterville TX 74093 TX 74183 Delbert TX 72381 Munster TX 72512 TX 76658 Waterville San Vista TX 74071 Georgetown TX 72379 Waterville TX 76658 Balance $1,535.15 $212.80 $1,955.40 $1,000.35 $525.00 $432.30 $714.25 $967.60 $1,846.75 $1,988.50 $688.95 $2,015.30