Report of template used for ticket logging

Report of template used for ticket logging

Hi Experts,

We have several service request templates that staff can use to log their ticket. We are trying to build a report using the Query Report to find out how many times the templates are used when logging a ticket.
The report output should be similar to below

TemplateName    Jan   Feb  .....
Template A              5       8  ...
Template B              3       0  .... 

I found an old discussion https://forums.manageengine.com/topic/report-used-service-request-templates using a MSSQL that suit my need.

Does anyone know how can I convert the query to PostgreSQL?

Thanks.