944media
asked on
MySQL Query - Max difference between date fields during one month period
We have an orders table that has a field called "sold_date" and another field called "rep_id"
Over a one month time period we want to see the AVERAGE number of days between sold_date and the MAXIMUM for each rep.
Any thoughts on how to do this?
Over a one month time period we want to see the AVERAGE number of days between sold_date and the MAXIMUM for each rep.
Any thoughts on how to do this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Please provide sufficient feedback so that I can understand why you did not follow up on this question.
Thank you
(°v°)