# Average number of members' replies per topic (excluding staff)

**URL:** <https://meta.discourse.org/t/average-number-of-members-replies-per-topic-excluding-staff/290618>\
**Category:** Data & reporting\
**Created:** [January 5, 2024, 11:35am UTC](https://meta.discourse.org/t/average-number-of-members-replies-per-topic-excluding-staff/290618 "2024-01-05T11:35:24Z")\
**Posts on this page:** 1\
**Showing post:** 1

<div class="post-metadata">

**Author:** ![Eloïse\_Barrège](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/elo%C3%AFse_barr%C3%A8ge/32/346353_2.png) [@Eloïse\_Barrège](https://meta.discourse.org/u/Elo%C3%AFse_Barr%C3%A8ge)\
**Post date:** [January 5, 2024, 11:35am UTC](https://meta.discourse.org/t/average-number-of-members-replies-per-topic-excluding-staff/290618/1 "2024-01-05T11:35:24Z")

</div>

First of all, happy new year !! 🎉

I would like to know the SQL query to use to obtain the average number of replies per topic made by users (excluding admins) per month.

Otherwise a way to have a ratio of the total number of posts published by members VS the total number of posts published by the staff per month.

Thank you !

---

_[View the full topic](https://meta.discourse.org/t/average-number-of-members-replies-per-topic-excluding-staff/290618)._