I have this query:
SELECT distinct(number), user_name, doc_total FROM `docs` inner join getuti on docs.user = getuti.user_number WHERE date = '2015-02-24'
and I get this result:
number user_name doc_total (this is the income amount)
70 SARAH 8.25
71 SARAH 2.7
72 SARAH 19.65
73 SARAH 13
74 SARAH 21.75
and so on...
How can I sum all the doc_total values dividing those for each user_name?
Correct server response should be a few rows containing (colum names are example):
If more is needed I can provide access to my learning mysql server:
Thanks for your kind help!