« first day (4954 days earlier)      last day (98 days later) » 

Martin Sleziak
Martin Sleziak
02:18
Top askers and answerers of the HNQs.
The same query on meta gives information about hot meta posts: Top askers and answerers
 
6 hours later…
Aaron
Aaron
08:19
@MartinSleziak Interesting. I wonder what the average-scores-per-question/answer are.
Martin Sleziak
Martin Sleziak
08:52
@Aaron You mean specifically for the HNQs?
Martin Sleziak
Martin Sleziak
09:16
Or do you mean average for a user? The above query gives total score and number of questions (answers); so one could simply divide them. But there is also the AVG function.
 
4 hours later…
Martin Sleziak
Martin Sleziak
13:04
Top users by average answer score and a non-CW version
Top users by average question score and a non-CW version
It's a bit weird that one user is shown there twice - once with UserDisplayName and once without.
Elements In Space
Elements In Space
13:20
@MartinSleziak You’ve got somekinda bug. For the these two, the table lists 2 entries for “Alex Basson” (user 36) with conflicting data.
@MartinSleziak Similarly for these two, and “Rafael Almeida” (user 53).
Martin Sleziak
Martin Sleziak
13:52
@ElementsInSpace Yes, I have mentioned this above.
Not really a bug - AFAICT SEDE really keeps some records for that user with UserDisplayName and some without.
The query is intended to include the deleted users (if possible) - you can easily modify it to use only UserId, if you prefer.
Elements In Space
Elements In Space
Which of the two entries is the real data?
Martin Sleziak
Martin Sleziak
Well, both.
Elements In Space
Elements In Space
User 36’s got 10 more answers, but 23 more total score.
Martin Sleziak
Martin Sleziak
As you can see here, SEDE keeps some entries for this user with DisplayName and some without it.
If you remove OwnerDisplayName you get 136 answers, as expected.
In the above query, they are split between two rows; they show 73+63=136 answers.
Elements In Space
Elements In Space
So I should add those columns together; It should be 63+73 answers, and 959+982 total score.
Yeah, okay.
Martin Sleziak
Martin Sleziak
14:00
Well, it all depends on what you wish to do with the query.
If you're not interested in deleted accounts, you can removed OwnerDisplayName completely - and this problem will no longer appear.
In any case, I posted this here mainly to prevent the room from freezing. (So all this is not important, I could have simply posted something like: "Do not freeze!")
Elements In Space
Elements In Space
I was just trying to get slightly better than 92nd place.
@MartinSleziak Thank you for all these DE links, they are interesting information.
Elements In Space
Elements In Space
14:39
The data with the OwnerDisplayname, is much older. I guess the split data is due to the site merge with Guitars.SE.
 
5 hours later…
Aaron
Aaron
19:09
@MartinSleziak Yes, this is what I meant: adding the AVG function. I just didn't have time to do it myself when I posted. I did mean for your original HNQ queries. BTW, what is "non-CW"?
Martin Sleziak
Martin Sleziak
@Aaron Only the posts which are not community wiki.

« first day (4954 days earlier)      last day (98 days later) »