I have 2 tables Games and Trading I use this formula sum(EntryFee * Rake/(100 Rake)*TotalEntry) in Games table to get the value
I am using this query in transaction table count(different user id) to get the value
Now I want to divide the value of [sum(EntryFee * Rake/(100 Rake)*TotalEntry)] by the value of [count(distinct UserID)]
For example sum(EntryFee * Rake/(100 Rake)*TotalEntry) = 90 and count(distinct UserID) = 3 Then 90/3 =30 How can I do this in MYSQL
result:
Example query