Query report all requests per technician

Query report all requests per technician

Hello

I'm looking for a report showing created requests per technician per day the last 7 days. 
I found this https://pitstop.manageengine.com/portal/community/topic/query-report-all-requests-per-technician  but I'm using  version : 10.5 Build 10500 Database :  postgres so the quarry isn't working for me. 

Any help would be helpful. 

TIA 
Daniel 

                  New to ADSelfService Plus?