I'm working on transactions for a data engineer class and I am tasked with making an atm like program.

my first task is to 1. Alters the bank table to include a total field which is based on the money in all the accounts and update our account information . Im guessing I should be using a view to do this. So how would that process go? Just create the view then insert into the new col? Also later on it states I will have to update the totals and here is the hint i was giving Hint: new totals do not need an UPDATE only a SELECT. I'm having a hard time grasping how a select statement would update the table.