updated query to return a zero balance even if there are no transactions assigned to the account