Challenge: Creating After Trigger

Now we will create a trigger to execute after updating the balance column of the BankAccounts table.
When triggered, it will invoke the function after_update_balance(), which logs the account number and the new balance into the UserLogs table, providing a record of balance modifications. The key idea is that we don't have to manually fill in the logs table - it will be done automatically by the trigger.

Note

Pay attention that triggers created for UPDATE operations can be designed to work only for update of the particular column. We can use the following statement to achive this:
CREATE TRIGGER trigger_name AFTER UPDATE OF col_name ON table_name.

Your task is to:

• Create the after_update_balance() function. It should return a trigger as its result and perform the necessary action, which is updating logs.
• Create an AFTER UPDATE trigger on the bankaccounts table. This trigger should use the designed function by executing it on each row of the update statement.