If you're interested in learning more about PostgreSQL, here are some additional resources:
GROUP BY collapses rows into groups.
BEGIN; UPDATE accounts SET balance = balance - 100 WHERE id = 1; UPDATE accounts SET balance = balance + 100 WHERE id = 2; COMMIT; -- or ROLLBACK;
Indexes speed up reads, slow down writes.