Sample SQL'er:

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

Close Parent Issue:

https://answers.atlassian.com/questions/726/how-do-i-get-a-parent-to-resolve-automatically-when-all-sub-tasks-are-resolved