How to find the running total with the columns like amount send and amount receive with sql query?

Answer 1

use alias , search against

eg: select send as a, received as b , (a+b) as running_total where date between '2020-12-01' and '2020-12-20'

you can also get a single row for certain period using group clause