Stack Exchange Data Explorer
3 hours ago
This space is for rent!
select p.id as [Post Link], count(*) from posts p inner j...
select count(*) from ( select userid, max(b.date) as crea...
select count(*) -- string_agg(cast(userid as nvarchar(max...
select * from users where profileimageurl like '%4f0af2dc...
select top 100 * from reviewtasks rt inner join reviewtas...
select string_agg(name,', ') from posttypes select top 1...
;with tagcreator as ( select ph.postid , ph.creationdate ...
select * from postswithdeleted where posttypeid = 6 sele...
select * from posts p where posttypeid = 6 and year(p.cre...
How can I find the election number for a given moderator nomination in the Posts table?
select top 100 id as [Post Link] , score , creationdate ,...
select top 100 * from ( select row_number() over ( partit...
select avg(ratio) from ( select p.id , sum(case when vote...
select top 100 text from posthistory where comment = '102'
site design / logo © 2018 Stack Exchange Inc; user contributions licensed under
cc by-sa 3.0