# Query for 'Approved By' Data

**URL:** https://meta.discourse.org/t/query-for-approved-by-data/172765
**Category:** Data & reporting
**Tags:** sql-query
**Created:** [December 9, 2020, 4:36pm UTC](https://meta.discourse.org/t/query-for-approved-by-data/172765 "2020-12-09T16:36:29Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![Chris27](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/chris27/32/141170_2.png) [@Chris27](https://meta.discourse.org/u/Chris27)
#### Post date: [December 9, 2020, 4:36pm UTC](https://meta.discourse.org/t/query-for-approved-by-data/172765/1 "2020-12-09T16:36:29Z")

</div>

I was wondering if there was an existing query that includes who approved/rejected signups, as well as posts in categories that require moderator approval.

Essentially I’m looking for a way to compile month over month:

| | Signups Appoved | Signups Rejected | Posts Approved | Posts Rejected |
| --- | --- | --- | --- | --- |
| Moderator A | 10 | 20 | 30 | 40 |
| Moderator B | 5 | 10 | 15 | 20 |

Thanks very much