Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

1 view

select groups, total_user_count from ( select *, case whe...

dec 9
2 views

select *, groups, total_user_count from ( select *, case ...

dec 9
3 views

select *, groups, total_user_count from ( select *, case ...

dec 9
3 views

select groups, total_user_count from ( select *, case whe...

dec 9
3 views

select groups, [user_count_in_group] = count(Id) over(par...

dec 9
3 views

select groups, [user_count_in_group] = count(Id) over(par...

dec 9
5 views

select groups, [user_count_in_group] = count(Id) over(par...

dec 9
5 views

select groups, count(groups), [user_count_in_group] = cou...

dec 9
5 views

select groups, count(groups) from ( select *, case when "...

dec 9
6 views

select groups, [user_count_in_group] = count(Id) over(par...

dec 9
6 views

select groups, total_user_count, [user_count_in_group] = ...

dec 9
8 views

select *, [user_count_in_group] = count(Id) over(partitio...

dec 9
9 views

select *, [user_count_in_group] = count(Id) over(partitio...

dec 9
9 views

select *, [percentages] = count(Id) over(partition by gro...

dec 9
9 views

select *, [percentages] = count(groups) over(partition by...

dec 9
9 views

select * from ( select *, case when "post_count" = 0 then...

dec 9
9 views

select *, case when "post_count" = 0 then '0' when "post_...

dec 9
10 views

select groups from (select *, case when "post_count" = 0...

dec 9
10 views

select *, case when "post_count" = 0 then '0' when "post...

dec 9
9 views

select *, case when "post_count" = 0 then '0' when "post...

dec 9
9 views

select *, case when "post_count" = 0 then '0' when "post...

dec 9
9 views

select *, case when "post_count" = 0 then '0' when "post...

dec 9
16 views

Number of questions/answers/posts per Year

dec 9 jon.doe43058
16 views

Number of questions/answers/posts per Year

dec 9 jon.doe43058
16 views

Number of questions/answers/posts per Year

dec 9 jon.doe43058
9 views

select count(Id) from (select u.Id, count(p.Id) as "post...

dec 9
9 views

select u.Id, count(p.Id) from Users u full outer join Pos...

dec 9
9 views

select round(1 - (cast(t1."with_post" as float)/cast(t2."...

dec 9
9 views

select *, round(1 - (cast(t1."with_post" as float)/cast(t...

dec 9
9 views

select *, (cast(t1."with_post" as float)/cast(t2."all" as...

dec 9
9 views

select *, 100-(cast(t1."with_post" as float)/cast(t2."all...

dec 9
9 views

select *, round(100-(cast(t1."with_post" as float)/cast(t...

dec 9
9 views

select *, round(100-(cast(t1."with_post" as float)/cast(t...

dec 9
9 views

select *, round(cast(t1."with_post" as float)/cast(t2."al...

dec 9
9 views

select *, round(100 - cast(t1."with_post" as float)/cast(...

dec 9
10 views

select *, cast(t1."with_post" as float)/cast(t2."all" as ...

dec 9
10 views

select *, cast(t1."with_post"/t2."all" as float) as "res"...

dec 9
10 views

select *, t1."with_post"/t2."all" as "res" from (select ...

dec 9
10 views

select *, t2."all"+t1."with_post" as "res" from (select ...

dec 9
10 views

select *, t2."all"/t1."with_post" as "res" from (select ...

dec 9
11 views

select * from (select count(distinct u.Id) as "with_post...

dec 9
12 views

SELECT Id AS [Post Link], (SELECT MAX(v) FROM (VALUES (Cl...

dec 9
11 views

select t1.with_post/t2."all" as "res" from (select count...

dec 9
11 views

select t2."all"/t1.with_post as "res" from (select count...

dec 9
10 views

select * from (select count(distinct u.Id) as "with_post...

dec 9
10 views

select * from (select count(distinct u.Id) as "with_post...

dec 9
9 views

select * from comments where PostId IN (select p2.Id a...

dec 9
9 views

select * from comments where PostId IN (select p1.Id a...

dec 8
8 views

select "group", count(Id) from (select u.Id, 'with_post'...

dec 8
8 views

select u.Id, 'with_post' as "group" from Users u full out...

dec 8

30 50 100 per page

2,175,317

queries

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

393 questions

680 answers

1.7k comments

79 tags

sep 12 most recent