The bank_account table has columns account_id (INT), account_balance (DECIMAL), and customer_loyalty(INT). Customer loyalty score is in the range of 0-10, with 10 being the highest loyalty score.
Write a transaction that tries to delete an account with a balance of 500 and then rolls back.
| account_id | account_balance | customer_loyalty |
|---|---|---|
| 56891 | 600 | 9 |
| 56983 | 1000 | 3 |
| 14573 | 9200 | 10 |
| 98457 | 20200 | 10 |
| 48536 | 500 | 2 |
| 54367 | 41000 | 5 |
| 32459 | 800 | 7 |