MY SQL

1) Delete all accounts at every branch located in Cambridge 2) Restore the rows from accounts that you removed in the previous question. You need to look at the data in the tables to do this (in two queries). (In practice, this would be done in conjunction with a high level language that would process each row returned and automatically generate the inserts). 3) Increase all accounts with balances over $10,000 by 6%. Customer Depositor Loan custnane custstr eet custcitv bankname linenun ant custname acctnum ones antico G-101 G-215 G-102 G-305 G-217 G-201 G-217 nson Downtown Brentwood Nanticoke Downtown Wicomico Somerset Nanticoke 1000 2000 1500 1500 C-23 antico Hayes Turner Sbody Cu Tumer Wharf C-93 Secret Cri sfield Williams Jones Adams Johnson Marion C-16 1300 cean G-301 G-302 G-400 G-402 G-102 et enn Jackson Baker Johnson Johnson Brooks EasternShore Salisbu een Secretary Branch Baker Rockfish Salisbury Salisbury Sbody banknamebankcity county assets Borrower Account Downtown Salisb BrentwoodFruitl and Nanticoke Wicomico Somerset PrincessAnn WI bankname acctnum balance custmame linenun Vienna Nithdale WI C-17 C-23 C-15 C-14 C-93 500 700 Jones WicomicO G-215 Talbot Worcester Dorchester Cambri Easton G-305 G-201 G-222 G-217 G-301 G-302 G-400 G-402 Som erset Jackson 900 700 750 Salisbury WI Brentwood Dorchester Worcester Worce ster NorthSide Salisb Williams Adams C-17 C-16 C-23 EastSide Northside 300