PGSQL database

PGSQL database

  • Can someone help with a query report for a PGSQL database for the guidlines below?

  • Response time - the time between ticket creation date and the first technician response
  • Resolution time - the time between ticket creation and closure dates
  • Average number of tickets created per day
  • Average number of tickets closed per day