06.All or Nothing

Sofia has 50. She wants to send 80 to Ava.

Start a transaction. Add 80 to Ava (account 1), then take 80 from Sofia (account 3). Then run SELECT * FROM accounts;. Which word in the error says what happened to the transaction?
Think before you run it: you end the transaction with COMMIT;. What is Ava's balance after it?
End the transaction.
Sofia sends Ava all her money: 50. Do it in one transaction and commit it.

Something unclear, wrong or missing?

Databaselab-db · PostgreSQL in your browser 0:00

SELECT * FROM accounts;

Ctrl↵runs the query · select text to run part of it

Objective 1 of 40/4 done