Sql Query to find when each issue status was last used/how many issues its listed against

[Hemanth Nagarajan]

I am looking for some query to find out when each issue status was last used/how many issues its listed against. 

I am new to querying from DB, any pre used queries would be helpful or some useful links to create them please.

[Radek Dostál]

DB is not meant for reporting purposes, and you will break your teeth trying to get anything meaningful out of it if you're not familiar in depth which tables Jira uses and how they relate to one another.

You could get all of these from plain and simple JQL search https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-fields#Advancedsearchingfieldsreference-StatusStatus and this can be combined with dates, so one you can get issue count e.g. 'status = open'; and then you can try something like 'status changed to open after startOfYear()' or a specific date, etc.

SQL is not necessary and not a good tool to use for data reports - Jira was not created with sql reporting in mind.