I need help creating a custom report showing average days to close a request by priority, for all priorities and by Tech

I need help creating a custom report showing average days to close a request by priority, for all priorities and by Tech

Hi,
 
I searched the forums and could not find a custom query or report to show me the average days to close a request by priority, for all priorities and by tech. Any help would be much appreciated.
 
MYSQL
Build 8009
 
Thanks
                New to ADManager Plus?

                  New to ADSelfService Plus?