Looking to get a % from my table(firsts) to give user stats..
I have :
Date 1 0
Date 2 0
Date 3 1
Date 4 0
The answer will be 25% because their is 1 instance of '1' divided by 4 dates = 25% ( i know you can do sums so sorry for basic explain. )
i have tried below query and get an error but it best explains what iam trying to do:
SELECT count(status) ,count(date_made) , status / date_made *100 from firsts where status = '1'
i ve tried for a few hours but i just get back answer of 100 or 7x100 = 700 etc..
sorry i get back 700 in my real app becuase their are 7 instances of '1'
Edited by glendango, 11 April 2018 - 10:59 AM.