1. Learn
    2. /
  2. Courses
    3. /
  3. Transactions and Error Handling in PostgreSQL

Exercise

Single statement transactions

Now you will work with a single statement transaction. Some types of saving accounts hold money that cannot be withdrawn on demand for individuals and corporations. The amount of the heldback money is stored in the RCONB550 field. These types of accounts promote bank stability and generate dependable revenue for the financial institution via fees and loan proceeds. Let's update FIELD48 to be '1' for each of these institutions to signify that they have this stability when it's over $100M.

Instructions 1/2

undefined XP
    1
    2
  • Update the flag in FIELD48 to be '1' when RCONB550 is greater than $100,000,000.
  • Count the number of records where FIELD48 is not '1'.