Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

2 views

select count(distinct(OwnerUserId)) from Posts where Post...

sep 16
2 views

select count(OwnerUserId) from Posts where Posts.Id in (s...

sep 16
2 views

SELECT Views, count(*) as Frequency FROM Users GROUP BY V...

sep 16
2 views

select count(distinct(OwnerUserId)) from Posts where Post...

sep 16
2 views

SELECT Views, count(*) FROM Users GROUP BY Views

sep 16
2 views

select count(distinct(Id)) from Posts where Posts.Id in (...

sep 16
1 view

select count(AllAcceptedAnswers.Id) as NoOfAcceptedAnswer...

sep 16
64 views

Median posts per user

sep 16 Mansi Ganatra
2 views

select count(*) from Posts where Posts.Id in (select Id f...

sep 16
2 views

select count(Posts.AcceptedAnswerId) from Posts where Pos...

sep 16
1 view

select Posts.Id,Posts.AcceptedAnswerId, Posts.ParentId as...

sep 16
1 view

select Posts.Id,Posts.AcceptedAnswerId, Posts.ParentId as...

sep 16
2 views

select count(Posts.Id) from Posts where Posts.Id in (sele...

sep 16
1 view

select Posts.Id,Posts.AcceptedAnswerId, Posts.ParentId as...

sep 16
1 view

select Posts.Id,Posts.AcceptedAnswerId, Posts.ParentId as...

sep 16
1 view

select Posts.Id,Posts.AcceptedAnswerId, Posts.ParentId as...

sep 16
1 view

select Posts.Id,Posts.AcceptedAnswerId, Posts.ParentId as...

sep 16
1 view

select top(5) displayname, upvotes, downvotes from users

sep 16
2 views

select count(Posts.AcceptedAnswerId) from Posts where Pos...

sep 16
3 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
3 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
3 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, PostT...

sep 16
3 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, PostT...

sep 16
3 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, PostT...

sep 16
3 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, PostT...

sep 16
3 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, PostT...

sep 16
3 views

select top(5)*from users

sep 16
3 views

select count(*) as NoOfQuestionsPerUser from(select Owner...

sep 16
5 views

SELECT count(Id) FROM Posts WHERE CreationDate BETWEEN '2...

sep 16
3 views

select convert(float, (convert(float, a.accepted)/convert...

sep 16
3 views

select convert(float, (convert(float, a.accepted)/convert...

sep 16
4 views

select OwnerUserId, count(*) from Posts where PostTypeID ...

sep 16
3 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score,PostTy...

sep 16
5 views

SELECT count(distinct(Id)) FROM Posts WHERE CreationDate ...

sep 16
4 views

SELECT count(distinct(Id)) FROM Posts WHERE CreationDate ...

sep 16
2 views

SELECT count(distinct(Id)) FROM Posts WHERE CreationDate ...

sep 16
2 views

SELECT count(distinct(Id)) FROM Posts WHERE CreationDate ...

sep 16
2 views

SELECT count(distinct(Id)) FROM Posts WHERE CreationDate ...

sep 16
2 views

SELECT count(distinct(Id)) FROM Posts WHERE CreationDate ...

sep 16
2 views

SELECT count(distinct(Id)) FROM Posts WHERE CreationDate ...

sep 16
4 views

SELECT count(distinct(Id)) FROM Posts WHERE CreationDate ...

sep 16
8 views

SELECT count(distinct(Id)) FROM Posts WHERE CreationDate ...

sep 16
7 views

SELECT count(distinct(Id)) FROM Posts WHERE CreationDate ...

sep 16
8 views

SELECT count(distinct(Id)) FROM Posts WHERE CreationDate ...

sep 16
8 views

SELECT count(distinct(Id)) FROM Posts WHERE CreationDate ...

sep 16
8 views

SELECT count(distinct(Id)) FROM Posts WHERE CreationDate ...

sep 16
8 views

SELECT count(distinct(Id)) FROM Posts WHERE CreationDate ...

sep 16
8 views

SELECT count(distinct(Id)) FROM Posts WHERE CreationDate ...

sep 16
8 views

SELECT count(distinct(Id)) FROM Posts WHERE CreationDate ...

sep 16
3 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score,PostTy...

sep 16
3 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score,PostTy...

sep 16
4 views

select OwnerUserId, count(*) as 'counts' from Posts where...

sep 16
2 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score,PostTy...

sep 16
2 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score,PostTy...

sep 16
2 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
2 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
2 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, Accep...

sep 16
2 views

DECLARE @UserId int = 8038345 SELECT --TOP 20 DownVotes,...

sep 16
2 views

select avg(Cast(NoOfQuestions as Float)) as NoOfQuestions...

sep 16
2 views

DECLARE @UserId int = 8038345 SELECT --TOP 20 Count(Down...

sep 16
2 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
2 views

DECLARE @UserId int = 8038345 SELECT --TOP 20 DownVotes,...

sep 16
2 views

DECLARE @UserId int = 8038345 SELECT --TOP 20 DownVotes,...

sep 16
2 views

DECLARE @UserId int = 8038345 SELECT --TOP 20 DownVotes,...

sep 16
3 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
3 views

select count(Id) from Posts where AcceptedAnswerId in (se...

sep 16
3 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
3 views

select count(Id) from Posts where AcceptedAnswerId in (se...

sep 16
3 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
3 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, Accep...

sep 16
2 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, Accep...

sep 16
2 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, Accep...

sep 16
2 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, Accep...

sep 16
3 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, Accep...

sep 16
3 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, Accep...

sep 16
3 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, Accep...

sep 16
3 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, Accep...

sep 16
3 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, Accep...

sep 16
3 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, Accep...

sep 16
3 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, Accep...

sep 16
3 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, Accep...

sep 16
9 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, Accep...

sep 16
9 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, Accep...

sep 16
7 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, Accep...

sep 16
7 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, Accep...

sep 16
7 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, Accep...

sep 16
7 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, Accep...

sep 16
7 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, Accep...

sep 16
5 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, Accep...

sep 16
5 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, Accep...

sep 16
5 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, Accep...

sep 16
12 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, Accep...

sep 16
12 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, Accep...

sep 16
12 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, Accep...

sep 16
12 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, Accep...

sep 16
12 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, Accep...

sep 16
12 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, Accep...

sep 16
11 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, Accep...

sep 16
11 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, Accep...

sep 16
11 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, Accep...

sep 16
12 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, Accep...

sep 16
4 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, Accep...

sep 16
6 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, Accep...

sep 16
1 view

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, Accep...

sep 16
1 view

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, Accep...

sep 16
4 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, Accep...

sep 16
4 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, Accep...

sep 16
4 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, Accep...

sep 16
4 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, Accep...

sep 16
4 views

SELECT TOP (25) Posts.ID, Posts.Title, Posts.Score, Accep...

sep 16
3 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
3 views

select count(*) accepted,sum(AnswerCount) as Ans from Pos...

sep 16
3 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
64 views

Median posts per user

sep 16 Mansi Ganatra
3 views

select count(*) accepted,sum(AnswerCount) from Posts p Jo...

sep 16
3 views

select count(Id) from Posts where OwnerUserId in (select ...

sep 16
3 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
3 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
3 views

select count(*) accepted,sum(AnswerCount) from Posts p Jo...

sep 16
3 views

select count(Id) from Posts where OwnerUserId in (select ...

sep 16
3 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
3 views

select Id from Posts where OwnerUserId in (select Id as U...

sep 16
64 views

Median posts per user

sep 16 Mansi Ganatra
3 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
3 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
64 views

Median posts per user

sep 16 Mansi Ganatra
1 view

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
2 views

select count(*) from Posts where PostTypeID = 1 group by ...

sep 16
1 view

select count(AllAcceptedAnswers.Id) as NoOfAcceptedAnswer...

sep 16
2 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
3 views

select count(*) from Posts where PostTypeID = 1 group by ...

sep 16
64 views

Median posts per user

sep 16 Mansi Ganatra
2 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
64 views

Median posts per user

sep 16 Mansi Ganatra
3 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
3 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
64 views

Median posts per user

sep 16 Mansi Ganatra
3 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
3 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
64 views

Median posts per user

sep 16 Mansi Ganatra
4 views

select count(AllAcceptedAnswers.Id) as NoOfAcceptedAnswer...

sep 16
3 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
4 views

select count(AllAcceptedAnswers.Id) as NoOfAcceptedAnswer...

sep 16
4 views

select count(AllAcceptedAnswers.Id) as NoOfAcceptedAnswer...

sep 16
4 views

select AVG(cast(DATEDIFF(s,CreationDate, ApprovalDate) as...

sep 16
4 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
5 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
4 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
5 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
5 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
3 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
3 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
3 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
2 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
3 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
3 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
2 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
1 view

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
3 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
3 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
3 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
3 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
3 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
3 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
3 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
3 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
3 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
2 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
2 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
3 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
2 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
3 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
3 views

select g.*,Users.Id as userId, Users.Reputation, Users.Up...

sep 16
64 views

Median posts per user

sep 16 Mansi Ganatra
64 views

Median posts per user

sep 16 Mansi Ganatra
7 views

select Views, Count(id) as CountUsers from Users group by...

sep 16
4 views

select AVG(DATEDIFF(d, CreationDate, ApprovalDate)) As Av...

sep 16
7 views

select AVG(DATEDIFF(d, CreationDate, ApprovalDate)) As Av...

sep 16
7 views

SELECT TOP 10 t.TagName, COUNT(DISTINCT OwnerUserId) AS t...

sep 16
7 views

select AVG(DATEDIFF(d, CreationDate, ApprovalDate)) As Av...

sep 16
6 views

select AVG(DATEDIFF(d, CreationDate, ApprovalDate)) As Av...

sep 16
7 views

select CreationDate from TagSynonyms where CreationDate l...

sep 16
7 views

SELECT TOP 10 t.TagName, COUNT(DISTINCT OwnerUserId) AS cnt

sep 16
7 views

SELECT TOP 10 t.TagName, COUNT(DISTINCT OwnerUserId) AS cnt

sep 16
7 views

select CreationDate from TagSynonyms

sep 16
7 views

select AVG(DATEDIFF(d, CreationDate, ApprovalDate)) As Av...

sep 16
7 views

select AVG(DATEDIFF(d, CreationDate, ApprovalDate)) from ...

sep 16
7 views

select AVG(DATEDIFF(d, CreationDate, ApprovalDate)) from ...

sep 16
7 views

select AVG(DATEDIFF(d, CreationDate, ApprovalDate)) from ...

sep 16
7 views

select AVG(DATEDIFF(d, CreationDate, ApprovalDate)) from ...

sep 16
7 views

select AVG(DATEDIFF(d, CreationDate, ApprovalDate)) from ...

sep 16
6 views

select AVG(DATEDIFF(d, CreationDate, ApprovalDate)) from ...

sep 16
7 views

select AVG(DATEDIFF(d, CreationDate, ApprovalDate)) from ...

sep 16

30 50 100 per page

1,347,087

queries

Q&A for committed Christians, experts in Christianity and those interested in learning more

11k questions

27k answers

86k comments

985 tags

sep 15 most recent