Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

15 views

SELECT * FROM Posts p WHERE 1=1 AND p.OwnerUserId = -1

may 20
23 views

How many upvotes do I have for each tag?

may 20
23 views

How many upvotes do I have for each tag?

may 20
23 views

How many upvotes do I have for each tag?

may 20
14 views

select top 100 p.Id as [Post Link], p.Score from Posts p ...

may 20
14 views

SELECT NumberOfPosts, COUNT(UserId) AS Us...

may 20
14 views

SELECT NumberOfPosts, COUNT(UserId) AS Us...

may 20
14 views

SELECT NumberOfPosts, COUNT(UserId) AS Us...

may 20
14 views

SELECT NumberOfPosts, COUNT(UserId) AS UserCount, UserCou...

may 20
14 views

SELECT NumberOfPosts, COUNT(UserId) AS UserCount, COUNT(*...

may 20
14 views

SELECT NumberOfPosts, COUNT(UserId) AS UserCount, COUNT(*...

may 20
14 views

SELECT NumberOfPosts, COUNT(UserId) AS UserCount, COUNT(U...

may 20
12 views

SELECT NumberOfPosts, COUNT(UserId) AS UserCount FROM ( S...

may 20
12 views

SELECT NumberOfPosts, COUNT(UserId) AS UserCount FROM ( S...

may 20
12 views

SELECT COUNT(DISTINCT u.Id) AS UserCount FROM Users u INN...

may 20
10 views

select count(*) from ( SELECT u.Id AS UserId, CASE WHEN C...

may 20
10 views

SELECT NumberOfPosts, COUNT(UserId) AS UserCount FROM ( S...

may 20
9 views

SELECT u.Id, CASE WHEN COUNT(DISTINCT p.Id) = 0 THEN 'noP...

may 20
9 views

SELECT u.Id, CASE WHEN COUNT(DISTINCT p.Id) > 0 THEN 99 E...

may 20
9 views

SELECT u.Id, COUNT(DISTINCT p.Id), CASE WHEN COUNT(DISTIN...

may 20
9 views

SELECT u.Id, COUNT(DISTINCT p.Id) FROM Users u LEFT JOIN ...

may 20
10 views

select count (u.ID) *100/(select count (u.ID) as count_of...

may 20
10 views

SELECT CAST(UsersWithoutPost AS FLOAT) / CAST(Users AS FL...

may 20
10 views

SELECT UsersWithoutPost/Users FROM ( SELECT COUNT(DISTINC...

may 20
10 views

SELECT distinct CAST(1 AS float) / CAST(3 AS float) FROM ...

may 20
12 views

SELECT 1/2FROM Users u LEFT JOIN Posts p on u.Id = p.Owne...

may 20
12 views

select count (u.ID) *100/(select count (u.ID) as count_of...

may 20
12 views

SELECT COUNT(DISTINCT CASE WHEN p.Id IS NULL THEN u.Id EL...

may 20
12 views

SELECT COUNT(DISTINCT CASE WHEN p.Id IS NULL THEN u.Id EL...

may 20
12 views

SELECT COUNT(DISTINCT CASE WHEN p.Id IS NULL THEN u.Id EL...

may 20
12 views

SELECT COUNT(DISTINCT u.Id) AS UserCount, COUNT(DISTINCT ...

may 20
12 views

SELECT COUNT(DISTINCT u.Id) AS UserCount, COUNT(DISTINCT ...

may 20
12 views

SELECT DISTINCT ( SELECT COUNT(DISTINCT u.Id) AS UserCoun...

may 20
12 views

SELECT DISTINCT ( SELECT COUNT(DISTINCT u.Id) AS UserCoun...

may 20
12 views

SELECT COUNT(DISTINCT u.Id) AS UserCount FROM Users u LEF...

may 20
13 views

select count (u.ID) as count_of_users from users u join ...

may 20
13 views

select a,b,a/b*1000000 from ( select distinct (SELECT CO...

may 20
13 views

select * from ( select distinct (SELECT COUNT(DISTINCT u...

may 20
13 views

select a/b*100 from ( select distinct (SELECT COUNT(DIST...

may 20
12 views

select a/b from ( select distinct (SELECT COUNT(DISTINCT ...

may 20
12 views

select distinct (SELECT COUNT(DISTINCT u.Id) AS UserCount...

may 20
12 views

select distinct (SELECT COUNT(DISTINCT u.Id) AS UserCount...

may 20
12 views

select distinct (SELECT COUNT(DISTINCT u.Id) AS UserCount...

may 20
12 views

select distinct (SELECT COUNT(DISTINCT u.Id) AS UserCount...

may 20
12 views

select (SELECT COUNT(DISTINCT u.Id) AS UserCount FROM Use...

may 20
11 views

select count (distinct u.ID) as percentage_of_total ...

may 20
11 views

select (SELECT COUNT(DISTINCT u.Id) AS UserCount FROM Us...

may 20
11 views

select (SELECT COUNT(DISTINCT u.Id) AS UserCount FROM Us...

may 20
11 views

select count (distinct u.ID) *100/ (SELECT COUNT(DISTIN...

may 20
11 views

select count (u.ID) *100/ (SELECT COUNT(DISTINCT u.Id) ...

may 20

30 50 100 per page