How many days was I active? (Returns amount of days when you've posted at least one answer, may be useful for another statistics since registrationdate isn't always representative for "user activity").

SELECT COUNT(DISTINCT CONVERT(char(10), CreationDate, 111)) AS days
FROM Posts
WHERE OwnerUserId = ##UserId##

SELECT Posts.id as [Post Link], Posts.Tags as [Tagged With]
FROM Votes, Posts
WHERE
(Votes.PostId=Posts.Id) AND
(Votes.VoteTypeId = 5) AND
(Votes.UserId=##User:int##) AND
(Posts.Tags LIKE '%<##TagName##>%') AND
(Posts.Title LIKE '%##BodyText##%') AND
(Posts.Body LIKE '%##TitleText##%');

I'm voting to close this question as off-topic because it is an unorganized mess, and users would have a better time just using the built-in search feature on Data Explorer than trying to sift through a bunch of unsorted answers on a Q&A pair.
– animuson♦Dec 7 '17 at 2:37

@animuson Woe that the Data Explorer site does not have voting itself or shared origin filtering. One is often better off starting from scratch than finding an existing query that does what one wants. Than again, maybe I'm not taking advantage of tweaking to get where I want.
– GrahamJan 29 at 13:19

The query nominally has data for all sites included in the SEDE (Stack Exchange, Data Explorer).

The privilege levels were taken from the StackExchange API, which seems to be current and accurate on most things.

There are no tables of privilege levels in the SEDE currently.

But the API data does not always agree with the FAQ... Which does not always agree with the Privileges pages

There is currently no way for a SEDE query to know what site's data
it is using. Hence, the privilege requirements are shown for all sites, whether
they apply or not.
The DB_Name() and DB_ID() functions can be used for this. Will roll into the query in the next day or two.

Number Text
------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
72 Belongs on superuser.com
39 You're welcome.
33 I've proposed a Stack Exchange-based Apple site that this question would be perfect for. Just go [here](http://area51.stackexchange.com/proposals/151/apple?referrer=EmsxHuwirbI%3d) and click "Follow" to help get the site up and running.
29 what operating system?
29 you're more than welcome.
28 belongs on superuser
20 Belongs on SuperUser.
18 **Avoid asking questions that are subjective, argumentative, or require extended discussion. This is not a discussion board, this is a place for questions that can be answered!**
17 What OS are you using?
14 Thank you very much!
13 What operating system are you using?
13 You're more than welcome :)
12 This is a website support issue. Not in the scope of SU.
11 awesome, thanks!
11 Sorry, but shopping type questions are discouraged on SU. http://meta.stackexchange.com/questions/36056/not-the-shopping
11 Thanks, question answered!
11 Which version of Windows?
10 Should be community wiki.
10 thank you very much
10 why the downvote?
10 You're most welcome.
9 This belongs on SuperUser.com
9 You're most welcome :)
9 You're most welcome!
8 Hello, welcome to Super User. Your question has been migrated here, where it is more adapted. To regain ownership over your question, you should create an account here, and associate it with your Stack Overflow account in user options.
8 Outside the scope of SU. Try asking on one of the sites listed here: http://meta.stackexchange.com/questions/4
8 Should be community wiki
8 superuser is for computer hardware and software related questions only. Websites are considered off topic. Please read the FAQ (http://superuser.com/faq).
8 Thank you for your answers!
8 This is not computer related. Please check the FAQ for more information.
8 Which operating system?
8 You're very welcome!
8 You're welcome!
7 I stand corrected.
7 Should be a wiki.
7 thanks for the link.
7 This belongs on superuser.
7 What version are you using?
7 What version of windows?
6 And http://superuser.com/questions/120461/transfer-time-of-a-cylinder
6 Community Wiki.
6 Excellent, thanks!
6 for what operating system?
6 Glad I could help.
6 Hello, welcome to Super User. Please review the FAQ (http://superuser.com/faq) to learn more about how this site works. This site is not a discussion board, this is a place for questions to be asked and answered. As such, you should not post a new answer if what you want to say doesn't actually answer the question.
6 How is this programming related?
6 http://superuser.com
6 I've raised http://meta.stackexchange.com/questions/45439/what-to-do-with-which-linux-distro-for-my-old-pc-questions-of-super-user/47075#47075 to discuss creating a faq about linux distributions. Please add any comments you have. Thanks.
6 Ok great thanks!
6 on what operating system?

Obviously people on Super User are mainly:

Friendly

Copy-pasting their "close explanation"

Asking for operating system

(and also a lot of "belongs on SU", thanks to SO migrations)

Special award for the anonymous person who is silently advertising his Apple proposal.

Do you have any way of ascertaining whether these guys actually belong to the places they claim to belong, I mean from the IP address etc? Otherwise, these statistics are meaningless.
– 299792458Aug 14 '14 at 6:05

I wonder who got the honour of being upvoted by Eric Lippert!
– Daniel VassalloJul 18 '10 at 21:29

Minor bug to the Reputation link; @endDate must be declared as datetime, otherwise the following error occurs, The data types date and datetime are incompatible in the subtract operator.
– Kyle KanosAug 18 '15 at 14:54

One query I found interesting is High Standards - it shows users that upvote relatively rarely in comparison to their reputation - so they either have high standards for upvoting or forgot about the upvote button at some point.

Can be used to generate graphs of average questions, answers, and up/down votes per day on a site, with a sliding windowed average for smoothing. For example, with a 90 day window size on the Spanish site, we can get a nice view of the site's growth over time:

And much smaller window sizes of course give more interesting short term info. Window size of 0 may be set to just display values directly. See comments at top of query.

@mmyers: they were introduced a few days before I hit the Epic, so it's still on time :) Mortarboard however was "too late". According to my /reputation page I already hit it on 2nd day of my SO activity.
– BalusCJul 6 '10 at 15:49

Analysis: Stack Overflow: It is best to ask questions in the 23 hour of the (UTC?) day on a Tuesday, but any work day will do. Asking a question in the 7 hour of Sunday and you're 23% (day) or 60% (hour) more likely to get a downvote.

Answers are much more uniform, both by day and by time of day of post.

Meta Stack Overflow: Totally different character (as expected) -- the worst time to ask is the 23 hour, on a Friday (of course) and the best time is the 18 hour on a Sunday. You're 58.5% (day) or 85.4% (hour) more likely to get a downvote at the former compared to the latter.

Answers on Meta Stack Overflow are best posted at the 21 hour of Friday, and most likely to receive downvotes at the 0 hour of Thursday.

EDIT: Seeing as I described the best and worst times as if they were hours of weekdays, I have included that actual query. So, in fact the best hour for Stack Overflow is 23 Thursday for questions and 23 Wednesday for answers and the worst is 7 Sunday for questions and 1 Saturday for answers.

Meta Stack Overflow really has too few downvotes to break them down to hours of the week, but in any case its best is 4 Sunday for questions and 8 Monday for answers, and its worst is 3 Thursday for questions and 12 Sunday for answers.

Nice queries! But .. Hey, I wasn't for 255 days continuously active! I registered one and half month before I actually started to post my first answer ;)
– BalusCMay 26 '10 at 18:16

@BalusC: yes, I know that, which is why I pushed for an official Last 30 Days top users ladder. I'll figure out how to write the query soon enough, or you can just write it and I'll learn from that.
– polygenelubricantsMay 26 '10 at 18:22

1

re: badge earners by quickness, we are missing dates on the badge table, already committed a fix will pick it up with the next data dump in a few days
– wafflesMay 27 '10 at 21:39

(These are just concept queries only for now; it should probably be a comment, but since this is CW I posed it as an "answer" -- everyone is free to take this and actually run with it. If no one picks it up, I'm sure I'll learn enough SQL to be able to write these queries myself eventually.)

Among all votes cast, ever, how many percent were cast within 5 minutes of the question being posted? Within an hour? Within a day? A week? A month? Six months? Etc.

(It seems that the generally accepted hypothesis is that most votes happens in the very early stage of a question's life, so it's good to see this supported by data)

I have this for your first query: odata.stackexchange.com/stackoverflow/q/7920/… . No logarithmic scale though, and I probably did something wrong because I have many votes before their posts were created. It can look better when the data dump offers visualization (which I'm considering adding myself).
– KobiJul 21 '10 at 4:54

When you have hundreds or thousands of Favorites on Stack Overflow, often you only want to find those matching a certain tag. The new search engine eliminated the ability to search using infavortes: tag, so this offers a near-replacement for that functionality as long as you only need to search on a tag name.

Based on the Accepted Answer Rate query, gives the percentage of answers you have where your answer is the highest voted one on the question, with at least one vote. Basically a measure of "community accepted answer" since asker does not always accept an answer, or accepts one that the community may find less helpful.

Single Site

This query can be run on a single site, and outputs the number of users active on the main site, the meta site, both, and the fraction of main users also active on meta. Active date range and min rep threshold can be set:

Your Top Comments, Network Wide

Here is the query. You'll need your network account ID which can be obtained from your profile URL at https://stackexchange.com. Plug it in and your top comments on all sites will be displayed, with clickable links.

I'm only just getting to grips with SQL Server syntax, so this has the number of three separate tags to look for, but listing bounties for several tags interleaved together seems useful as these things go.

SELECT
Count(Posts.Id) AS Answers,
(SELECT MAX(Score)
FROM (SELECT TOP 50 percent Score
FROM Posts as PU
WHERE PostTypeId = 2 and CommunityOwnedDate IS NULL and PU.OwnerUserId = ##UserId##
ORDER BY Score
) as t
) AS MedianAnswerScore
FROM
Posts
WHERE
PostTypeId = 2 and CommunityOwnedDate IS NULL and OwnerUserId = ##UserId##

SELECT
TOP 100
Users.Id,
DisplayName,
Count(Posts.Id) AS Answers,
(SELECT MAX(Score)
FROM (SELECT TOP 50 percent Score
FROM Posts as PU
WHERE PostTypeId = 2 and CommunityOwnedDate IS NULL and PU.OwnerUserId = Users.Id
ORDER BY Score
) as t
) AS MedianAnswerScore
FROM
Posts
INNER JOIN
Users ON Users.Id = OwnerUserId
WHERE
PostTypeId = 2 and CommunityOwnedDate IS NULL
GROUP BY
Users.Id, DisplayName
HAVING
Count(Posts.Id) > 100
ORDER BY
MedianAnswerScore DESC

This query grabs the Approvals/Rejects of Suggested Edits on a per-site basis (on the overall outcome of the Suggestion, not the per user-vote breakdown) for comparison purposes. Do you sometimes feel like a site seems to reject more suggestions compared to another? Check and find out!

Shoutouts:
Ability to query across all sites unabashedly stolen from this meta

Caveats:

Meta sites are also included in the query, but due to the nature of meta sites the suggested approvals/rejects on these sites are either

Too small in number to seriously count as a 'pattern'

Skew towards 'approved' due to the nature of the users suggesting the edits (ones that care about the site/rules), or