Skip to content

Queries Comparing Discord Guilds

  1. What are the discord guilds are in the database?
  2. Order discord Guild's by the oldest message?
  3. What discord guilds have the most messages?
  4. What discord guild's have the most Users?
  5. What discord guild's have the most channels?
  6. What percentage of users on each Discord Guild posted less than 1, 3, 10, or 100 messages?
  7. What percentage of all messages in Discord Guild came from 1, 10, and 100 Authors?
  8. What is the activity per month of each discord guild measured in messages per month?
    1. How much activity for a specific discord guild per day of week?
  9. What is the activity of each month for each guild normalized on a single graph?
  10. What is the name of the most active channel in each discord guild?
    1. What are the most active channels in a specific discord guild?
    2. When was the most active month for the most active channel in each discord guild?
  11. What is the average message count for most active X days of a Discord Guild?
    1. How to get message count by day for a particular discord guild?
  12. What percentage of days actually have messages for a specific discord guild?
  13. What is the average half life of top x% active users?
  14. What are the sum of messages in each discord guild?
  15. What authors posted the most in each discord guild?