We can't wait for data to compete. Try and beat this:

select avg(txn_amt) as predicted_income from customer_txn_data where txn_direction = 'in' group by customer_id