How can I calculate my player's Life Time Value?
You want to know the average amount of user LTV (Life time value) , calculated by summary of all the deposits , divided by the distinct number of users .
select sum(total_pay)/ count(*) as ltv
from accounts
