Okay, so I think I have the query down (not just close like last time I did a Data Explorer query)
Select 47 - Datediff(month, p.CreationDate, Current_Timestamp) as Age,
convert(DECIMAL(10,2), sum(case when p.AcceptedAnswerId is null then 0
) / count(p....
If you are looking for statistics about this site then data.stackexchange.com is the place to go. You can query the SE database about practically anything. If you don't know SQL you can run some of the other queries that people have made.
Here are some relevant queries for your question:
What is my average question score?
What is my average answer score?
We can't observe this directly, but we can group posts by the hour of the day in which they were posted and compute the average scores of each group. I wrote a query for this here. From the graph, it shows that the most activity happens near midnight UTC (or whatever $0$ is), with posts averaging a score of $2.45$ and the least happens near 9:00 UTC, with an ...
I amalgamated some queries in order to get what OP wants:
This query does what was requested.
It only counts undeleted answers;
As was expected, without some lower bound on the denominator the results are pretty skewed to singularities: on the top 100 with the requirement of at least 1 answer, the highest number of answers is 3;
The search parameter is:answer returns only answers, and you can sort this by votes: search results. This worries about score, and not simply upvotes (so a hypothetical answer with a huge number of up- and down-votes is likely omitted). It also doesn't give you the "top $N$", but it does order them correctly.
You can also use the SEDE, but the results here ...
One of several queries that could be used for this purpose is Get all your posts and comments. The last column indicates the type of post: 1 = question, 2 = answer, 3 = comment.
For your convenience, here it the query with your UserId pre-filled. You do not need to create a Data Explorer account; queries can be run anonymously (you'll just get a CaptCha to ...
Data Explorer does not have real-time data. You can see the date stamp of the latest data dump on its frontpage.
Given the visibility of the query, it is likely that someone was using it (with the same or different tag parameter, since tags overlap) since the last data dump was generated.
Possible solutions: (a) pick a different tag; (b) pick a different ...
I suppose that using something like PostHistoryType.Id=2 and PostType.id=5 you could find a list of tag-wikis you have created.
Try for example here for a somewhat similar query (although that query was designed for answers and questions, so the results do not look that fine for tag-wikis. There is definitely a space for improvement; perhaps there already is ...
Yes, see Recent questions with only one tag
. It actually returns all questions with the given tag as the only tag, with most recent first.
This is easier to do with the built-in search. Precede the undesired tags with -. For example, you can search for
[abstract-algebra] [polynomials] -[homework] -[group-theory]
to get all questions questions tagged ...
Here is a query that gives the number of edits per month:
(it is adapted from the query that @mixedmath linked in the comments; it simply groups all edits by month and displays the graph). Of course the data from this month is skewed because the month is not over yet.
Here is a query that gives the top 200 users ranked by number of badges.
Additionally, here is a query that gives the top 50 users by each of:
number of gold badges,
number of silver badges, and
number of bronze badges.
Searchable leaderboard is available; however the search is by user name, not by hat name.
I don't think this is something we could realistically put in the data explorer. It would be a bit of a challenge because the event is very short-lived, and we'd have to do some interesting hackery to get the data into data explorer itself (creating the dump, ...
You don't really need to check the database per se (which I interpret to mean either the SEDE, or the public data dumps). The search options available on the main site should be sufficient.
[elementary-number-theory] will return posts tagged elementary-number-theory.
answers:0 will return questions with no answers. (Really, truly zero answers; not just "...
I'm not sure if that's already included in your statistics, but there are a lot of relatively easy questions that have an answer which is stated as a comment. This will be ok for the one who asks the question, but I also want to point out, that this habit is a bit unnerving for someone who wants to answer an unanswered question only to find, that there is an ...