Sample SQL'er:

http://confluence.atlassian.com/display/JIRACOM/Example+SQL+queries+for+JIRA#ExampleSQLqueriesforJIRA-FindIssuesAffectedbyaGivenTransitioninaSpecificTimeRange