You might have a look in Topics tagged data-explorer or Discourse Data Explorer or What cool data explorer queries have you come up with? for some examples.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Active users in the last 30 days | 3 | 376 | September 5, 2016 | |
| SQL query for users who have posted on a date (or date range) | 8 | 1482 | July 11, 2021 | |
| Users Last Seen Since (Since N Days Ago) | 0 | 164 | May 1, 2016 | |
| Show data for last X days | 3 | 480 | January 24, 2022 | |
| User_stats with a proper time stamp | 8 | 1069 | August 15, 2023 |