Stack Exchange
log in
help
Stack Exchange Data Explorer
Home
Queries
Users
Compose Query
peterh
Registered User
member for
3885 days
seen
May 18 '18 at 23:19
location
I like to write network-wide queries.
Check my favorites.
edited
favorite
recent
WITH Raw AS ( SELECT A.Id, RANK() OVER (PARTITION BY Q.Id...
Percentage of the answer upvotes given to Nth answers
SELECT DATEDIFF(s, '2018-05-03 00:41:10', '2046-05-15 17:...
WITH Raw AS ( SELECT *, CONVERT(VARCHAR(32), HASHBYTES('M...
SELECT LOG(EXP(1));
Tag entropy density per month
Users with the highest combined reputation, network-wide
Moderator identifier
Entropy density of answer upvotes on month basis
Entropy density of answer upvotes on month basis, tag-filterable
Create a temporary table for the LOG(n!), large and fast
SELECT DATEFROMPARTS( DATEPART(yyyy, Votes.CreationDate),...
Is the Area51 dying?
Posts closed/reopened most times by the community
Steward badge history of the most steward badge holders, network-wide
1
2
3
4
5
…
26
next
Data Explorer works best with JavaScript enabled