Requests time spent report

Requests time spent report

If I generate preinstalled time spent reports I see that a request which has more than 1 worklog is duplicated in the report accordingly to worklog quantity. Can someone share Postgres SQL query which generate time spent report where every single request has summarized worklog time? For example we have request with 3 worklogs 1 hour each. I want to see in the report 1 string with request ID, Title and 3 hours spent.

                  New to ADSelfService Plus?