Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

9 views

SELECT u.DisplayName, u.WebsiteUrl, u.Reputation, u.Creat...

jun 7
8 views

SELECT u.DisplayName, u.WebsiteUrl, u.Reputation, u.Creat...

jun 7
8 views

SELECT u.DisplayName, u.WebsiteUrl, u.Reputation, u.Creat...

jun 7
8 views

SELECT u.DisplayName, u.WebsiteUrl, u.Reputation, u.Creat...

jun 7
8 views

SELECT u.DisplayName, u.WebsiteUrl, u.Reputation, u.Creat...

jun 7
19 views

Querry 1

jun 6
10 views

select top 10 id as ID, displayname as nik, reputation as...

jun 6
10 views

select top 10 id as ID, displayname as nik, reputation as...

jun 6
10 views

select top 10 id as ID, displayname as nik, reputation as...

jun 6
10 views

select top 10 id as ID, displayname as nik, reputation as...

jun 6
10 views

select top 10 id, displayname, reputation from users wher...

jun 6
10 views

select top 10 id, displayname, reputation from users wher...

jun 6
10 views

select top 10 id, displayname, reputation from users wher...

jun 6
10 views

select top 10 id, displayname from users where displaynam...

jun 6
10 views

select top 10 * from users;

jun 6
10 views

select top 10 id, score, lastactivitydate from posts orde...

jun 6
10 views

select top 10 * from posts

jun 6
9 views

select count(id) from posts;

jun 6
10 views

select count(id) from posts;

jun 6
10 views

select count(id) from posts;

jun 6
10 views

select count(id) from posts;

jun 6
10 views

select count(id) from posts;

jun 6
10 views

select count(id) from posts;

jun 6
10 views

select count(id) from posts;

jun 6
10 views

select count(id) from posts;

jun 6
10 views

select count(id) from posts;

jun 6
10 views

select count(id) from posts;

jun 6
10 views

select count(id) from posts;

jun 6
10 views

select count(id) from posts;

jun 6
20 views

5. Create a result set with the following format for posts that have 5 or more tags where tags is a

jun 6
24 views

4. What percentage of posts have no comments attached to them?

jun 6
12 views

SELECT CONCAT(CAST((CAST(Post_NoComments AS float) / NumP...

jun 6
11 views

SELECT (CAST(Post_NoComments AS float) / NumPosts) * 100 ...

jun 6
11 views

SELECT * from Posts where Id in (20112887, 769621, 201119...

jun 6
11 views

SELECT (CAST(Post_NoComments AS float) / NumPosts) * 100....

jun 6
11 views

SELECT (CAST(Post_NoComments AS float) / NumPosts) * 100 ...

jun 6
9 views

SELECT (CAST(Post_NoComments AS float) / NumPosts) * 100 ...

jun 6
10 views

SELECT (CAST(NoCommentPosts AS float) / TotalPosts) * 100...

jun 6
9 views

SELECT (CAST(NoCommentPosts AS float) / TotalPosts) * 100...

jun 6
11 views

SELECT (CAST(NoCommentPosts AS float) / TotalPosts) * 100...

jun 6
11 views

SELECT (CAST(NoCommentPosts AS float) / TotalPosts) * 100...

jun 6
11 views

SELECT (CAST(NoCommentPosts AS float) / TotalPosts) * 100...

jun 6
12 views

SELECT (CAST(NoCommentPosts AS float) / TotalPosts) * 100...

jun 6
8 views

SELECT top 1000 * FROM Posts where PostTypeId = 2 and Sco...

jun 6
11 views

SELECT top 1000 * FROM Posts where PostTypeId = 2 and Sco...

jun 6
8 views

SELECT CommentCount, Round(COUNT(CommentCount) * 100.0 / ...

jun 6
24 views

4. What percentage of posts have no comments attached to them?

jun 6
8 views

SELECT DATEADD(WEEK, DATEDIFF(WEEK, 0, CreationDate),0) [...

jun 6
20 views

select Id as [Post Link],CreationDate from Posts where (...

jun 6 David Carlisle
20 views

select Id as [Post Link],CreationDate from Posts where (...

jun 6 David Carlisle
20 views

select Id as [Post Link],CreationDate from Posts where Cl...

jun 6 David Carlisle
20 views

select Id as [Post Link],Title,CreationDate from Posts wh...

jun 6 David Carlisle

30 50 100 per page

2,116,901

queries

Q&A about the site for administrators, end users, developers and designers for Craft CMS

57 questions

74 answers

267 comments

81 tags

may 3 most recent