SQL functions are blocks of code that take one or more inputs and return a single output. You can use them to perform calculations, transformations, validations, and other logic on your data.

for example we have these 2 tables, invoice and payments - when a client makes a payment we want it to update the invoice field "total paid" -- now this means this trigger gets activated for each row ...