Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

91 views

SELECT PostTypeId, RepCategory, count(*) AS NumPosts, Tag...

oct 11 PeterJames
91 views

SELECT PostTypeId, RepCategory, count(*) AS NumPosts, Tag...

oct 11 PeterJames
91 views

SELECT PostTypeId, RepCategory, count(*) AS NumPosts FROM (

oct 11 PeterJames
91 views

SELECT PostTypeId, count(*) AS NumPosts FROM ( SELECT p.P...

oct 11 PeterJames
91 views

SELECT p.PostTypeId, count(*) AS NumPosts, CASE WHEN u.Re...

oct 11 PeterJames
91 views

SELECT p.PostTypeId, count(*) AS NumPosts, CASE WHEN u.Re...

oct 11 PeterJames
220 views

select count(*) from posts where viewcount > (select avg(...

oct 11 jon.doe45923
220 views

select count(*) from posts where viewcount > 833

oct 11 jon.doe45923
220 views

select count(*) from posts where viewcount > 833

oct 11 jon.doe45923
220 views

select viewcount, id, count(*), sum(posts.viewcount) from...

oct 11 jon.doe45923
220 views

select viewcount, id, count(*) from posts where viewcount...

oct 11 jon.doe45923
91 views

SELECT p.PostTypeId, count(*) AS NumPosts, CASE WHEN u.Re...

oct 11 PeterJames
220 views

select viewcount, id, sum(posts.viewcount) as total_viewc...

oct 11 jon.doe45923
220 views

select viewcount, id, sum(posts.viewcount) as total_viewc...

oct 11 jon.doe45923
91 views

SELECT p.PostTypeId, count(*) AS NumPosts, CASE WHEN u.Re...

oct 11 PeterJames
133 views

SELECT count(*) FROM Posts WHERE ParentId = 1

oct 11 jon.doe45922
220 views

select viewcount, id from posts where viewcount > 833 gro...

oct 11 jon.doe45923
133 views

SELECT count(*) FROM Posts WHERE ParentId = 3414789

oct 11 jon.doe45922
220 views

select viewcount from posts where viewcount > 833 group b...

oct 11 jon.doe45923
133 views

SELECT Id, Reputation FROM Users ORDER BY Reputation DESC

oct 11 jon.doe45922
133 views

SELECT AVG(Reputation) FROM Users WHERE CreationDate > '2...

oct 11 jon.doe45922
6 views

Select count(*) from posts where ViewCount > (Select avg(...

oct 11 jon.doe45923
133 views

SELECT count(*) FROM Posts WHERE PostTypeId = 2 AND Score...

oct 11 jon.doe45922
220 views

select viewcount, count(*) from posts where viewcount > 833

oct 11 jon.doe45923
91 views

SELECT p.PostTypeId, count(*) AS NumPosts, count(CASE WHE...

oct 11 PeterJames
133 views

SELECT count(*) FROM Posts WHERE CreationDate > '2023-03-...

oct 11 jon.doe45922
220 views

select viewcount from posts where viewcount > 833

oct 11 jon.doe45923
133 views

SELECT count(*) FROM Posts JOIN Comments ON Comments.Post...

oct 11 jon.doe45922
220 views

select avg(viewcount) as average_viewcount from posts

oct 11 jon.doe45923
220 views

select avg(viewcount) from posts

oct 11 jon.doe45923
133 views

SELECT count(*) FROM Posts WHERE CreationDate > '2023-01-...

oct 11 jon.doe45922
91 views

SELECT p.PostTypeId, count(*) AS NumPosts, count(CASE WHE...

oct 11 PeterJames
220 views

select viewcount from posts

oct 11 jon.doe45923
7 views

SELECT * FROM posts WHERE posttypeid =1 ORDER BY CommentC...

oct 11 jon.doe45923
220 views

select commentcount from posts join posttypes on posts.po...

oct 11 jon.doe45923
220 views

select * from posts join posttypes on posts.posttypeid = ...

oct 11 jon.doe45923
91 views

SELECT p.PostTypeId, count(*) AS NumPosts, count(CASE WHE...

oct 11 PeterJames
220 views

select commentcount from posts join posttypes on posts.po...

oct 11 jon.doe45923
220 views

select commentcount from posts join posttypes on posts.po...

oct 11 jon.doe45923
220 views

select commentcount from posts join posttypes on posts.id...

oct 11 jon.doe45923
91 views

SELECT p.PostTypeId, count(*) AS NumPosts, count(CASE WHE...

oct 11 PeterJames
133 views

SELECT count(*) FROM Posts JOIN PostTags ON Posts.Id = Po...

oct 11 jon.doe45922
133 views

SELECT * FROM Posts JOIN PostTags ON Posts.Id = PostTags....

oct 11 jon.doe45922
133 views

SELECT count(*) FROM Posts JOIN PostTags ON Posts.Id = Po...

oct 11 jon.doe45922
91 views

SELECT p.PostTypeId, count(*) AS NumPosts, count(CASE WHE...

oct 11 PeterJames
133 views

SELECT count(*) FROM Posts

oct 11 jon.doe45922
220 views

select commentcount from posts order by commentcount desc

oct 11 jon.doe45923
133 views

SELECT count(*) FROM Tags

oct 11 jon.doe45922
220 views

select * from posts order by commentcount desc

oct 11 jon.doe45923
220 views

select commentcount from posts order by commentcount desc

oct 11 jon.doe45923

30 50 100 per page

2,261,697

queries

Q&A about the site for serious players and enthusiasts of chess

415 questions

567 answers

1.2k comments

82 tags

jul 16 most recent