Possible to generate a report query?

We are running 7.6 build 7610 on MSSQL. (Upgrading shortly to 8.0 build 8011)

I'd like to be able to generate a report / set of reports with the following information for Request tickets:
- Request ID
- Priority
- Group
- Technician
- Request Status
- Created Time

Where:
- Request status is not Closed or Resolved

Specific views I'd like.
- Additional columns: counts of tickets between 0 to <= 30 days, > 30 to <= 60 days, > 60 to <= 90 days, > 90 days grouped in rows by Group.
- Additional columns: counts of tickets between 0 to <= 30 days, > 30 to <= 60 days, > 60 to <= 90 days, > 90 days grouped in rows by Technician.

Is this possible?