Browse Queries - Stack Exchange Data Explorer

All Queries

featured recent favorite popular everything

55 views

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

sep 20
244 views

SELECT TOP 5 COUNT(Id) as count_posts, CONCAT(YEAR(Creati...

sep 20 jon.doe45748
244 views

SELECT TOP 5 COUNT(Id) as count_posts, CONCAT(YEAR(Creati...

sep 20 jon.doe45748
244 views

SELECT TOP 5 COUNT(Id) as count_posts, CONCAT(YEAR(Creati...

sep 20 jon.doe45748
244 views

SELECT TOP 5 COUNT(Id) as count_posts, CONCAT(YEAR(Creati...

sep 20 jon.doe45748
244 views

SELECT TOP 5 COUNT(Id) as count_posts, CONCAT(YEAR(Creati...

sep 20 jon.doe45748
244 views

SELECT TOP 5 COUNT(Id) as count_posts, CONCAT(YEAR(Creati...

sep 20 jon.doe45748
18 views

SELECT TOP 5 Id, DisplayName, Location FROM Users WHERE L...

sep 20
18 views

SELECT TOP 5 Name,COUNT(UserId) as cnt FROM Badges GROUP ...

sep 20
8 views

SELECT COUNT(Id) AS num_of_posts,MIN(CreationDate) AS min...

sep 20
18 views

SELECT COUNT(Id) AS num_of_posts,MIN(CreationDate) AS min...

sep 20
18 views

SELECT COUNT(Id) AS num_of_posts,MIN(CreationDate) AS min...

sep 20
55 views

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

sep 20
51 views

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

sep 20
55 views

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

sep 20
59 views

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

sep 20
56 views

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

sep 20
48 views

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

sep 20
56 views

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

sep 20
59 views

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

sep 20
55 views

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

sep 20
51 views

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

sep 20
55 views

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

sep 20
55 views

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

sep 20
54 views

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

sep 20
56 views

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

sep 20
53 views

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

sep 20
57 views

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

sep 20
49 views

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

sep 20
50 views

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

sep 20
36 views

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

sep 20
36 views

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

sep 20
35 views

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

sep 20
35 views

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

sep 20
50 views

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

sep 20
63 views

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

sep 20
44 views

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

sep 20
48 views

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

sep 20
11 views

SELECT Id, DisplayName, Location FROM Users WHERE Locatio...

sep 20
11 views

WITH BadgeCounts AS ( SELECT Name AS label_name, COUNT(*)...

sep 20
47 views

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

sep 20
48 views

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

sep 20
56 views

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

sep 20
59 views

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

sep 20
55 views

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

sep 20
51 views

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

sep 20
55 views

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

sep 20
55 views

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

sep 20
54 views

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

sep 20
56 views

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

sep 20
53 views

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

sep 20
57 views

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

sep 20
49 views

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

sep 20
50 views

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

sep 20
36 views

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

sep 20
36 views

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

sep 20
35 views

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

sep 20
35 views

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

sep 20
50 views

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

sep 20
63 views

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

sep 20
11 views

WITH PostCounts AS ( SELECT YEAR(CreationDate) AS year, M...

sep 20
19 views

SELECT CONVERT(CHAR(7), CreationDate, 120) as Post_Date, ...

sep 20
38 views

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

sep 20
47 views

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

sep 20
48 views

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

sep 20
44 views

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

sep 20
48 views

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

sep 20
56 views

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

sep 20
59 views

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

sep 20
55 views

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

sep 20
51 views

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

sep 20
55 views

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

sep 20
55 views

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

sep 20
54 views

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

sep 20
56 views

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

sep 20
53 views

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

sep 20
57 views

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

sep 20
49 views

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

sep 20
50 views

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

sep 20
36 views

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

sep 20
36 views

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

sep 20
35 views

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

sep 20
35 views

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

sep 20
50 views

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

sep 20
63 views

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

sep 20
35 views

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

sep 20
39 views

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

sep 20
31 views

HW2-1

sep 20
38 views

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

sep 20
32 views

HW2-1

sep 20
43 views

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

sep 20
32 views

HW2-1

sep 20
37 views

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

sep 20
33 views

HW2-1

sep 20
37 views

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

sep 20
32 views

HW2-1

sep 20
32 views

HW2-1

sep 20
36 views

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

sep 20
16 views

SELECT TOP 5 COUNT(Id) as count_posts, CONVERT(CHAR(7), C...

sep 20
38 views

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

sep 20
16 views

SELECT COUNT(Id) as count_posts, CONVERT(CHAR(7), Creatio...

sep 20
16 views

SELECT COUNT(Id) as count_posts, MIN(CreationDate) as min...

sep 20
15 views

SELECT COUNT(Id) as count_posts, MIN(CreationDate) as min...

sep 20
38 views

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

sep 20
38 views

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

sep 20
43 views

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

sep 20
325 views

SELECT TOP 5 Id AS id, DisplayName AS displayname, Locati...

sep 20 jon.doe45746
325 views

SELECT Id AS id, DisplayName AS displayname, Location AS ...

sep 20 jon.doe45746
325 views

SELECT Id AS id, DisplayName AS displayname, Location AS ...

sep 20 jon.doe45746
43 views

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

sep 20
34 views

3. Provide a leaderboard of users with correct answers who have commented on at least 10 unique pos

sep 20
43 views

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

sep 20
43 views

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

sep 20
38 views

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

sep 20
38 views

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

sep 20
38 views

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

sep 20
36 views

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

sep 20
37 views

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

sep 20
37 views

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

sep 20
43 views

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

sep 20
38 views

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

sep 20
39 views

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

sep 20
35 views

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

sep 20
38 views

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

sep 20
47 views

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

sep 20
48 views

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

sep 20
44 views

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

sep 20
48 views

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

sep 20
56 views

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

sep 20
59 views

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

sep 20
55 views

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

sep 20
51 views

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

sep 20
55 views

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

sep 20
55 views

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

sep 20
54 views

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

sep 20
56 views

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

sep 20
53 views

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

sep 20
57 views

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

sep 20
49 views

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

sep 20
50 views

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

sep 20
36 views

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

sep 20
36 views

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

sep 20
35 views

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

sep 20
35 views

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

sep 20
50 views

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

sep 20
63 views

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

sep 20
325 views

SELECT Id AS id, DisplayName AS displayname, Location AS ...

sep 20 jon.doe45746
35 views

3. Provide a leaderboard of users with correct answers who have commented on at least 10 unique pos

sep 20
325 views

SELECT Id AS id, DisplayName AS displayname, Location AS ...

sep 20 jon.doe45746
325 views

SELECT Id AS id, DisplayName AS displayname, Location AS ...

sep 20 jon.doe45746
325 views

SELECT Id AS id, DisplayName AS displayname, Location AS ...

sep 20 jon.doe45746
23 views

SELECT COUNT(Id) as count_posts, MIN(CreationDate) as min...

sep 20
325 views

SELECT Id AS id, DisplayName AS displayname, Location AS ...

sep 20 jon.doe45746
325 views

SELECT Id AS id, DisplayName AS displayname, Location AS ...

sep 20 jon.doe45746
12 views

SELECT COUNT(Id), MIN(CreationDate) as min_date, MAX(Crea...

sep 20
23 views

SELECT COUNT(Id), MIN(CreationDate) as min_date, MAX(Crea...

sep 20
15 views

SELECT COUNT(Id), MIN(CreationDate) as min_date, MAX(Crea...

sep 20
16 views

SELECT COUNT(Id), MIN(CreationDate) as min_date, MAX(Crea...

sep 20
16 views

SELECT COUNT(Id), MIN(CreationDate) as min_date, MAX(Crea...

sep 20
16 views

SELECT COUNT(Id), MIN(CreationDate) as min_date, MAX(Crea...

sep 20
19 views

SELECT COUNT(Id), MIN(CreationDate) as min_date, MAX(Crea...

sep 20
33 views

3. Provide a leaderboard of users with correct answers who have commented on at least 10 unique pos

sep 20
325 views

SELECT Id AS id, DisplayName AS displayname, Location AS ...

sep 20 jon.doe45746
325 views

SELECT Id, DisplayName, Location FROM Users WHERE Locatio...

sep 20 jon.doe45746
32 views

3. Provide a leaderboard of users with correct answers who have commented on at least 10 unique pos

sep 20
17 views

SELECT Id, DisplayName, Location FROM Users WHERE Locatio...

sep 20
17 views

SELECT Id, DisplayName, Location FROM Users WHERE Locatio...

sep 20
325 views

SELECT * FROM Users

sep 20 jon.doe45746
17 views

SELECT COUNT(*) AS NY_user_count FROM Users WHERE Locatio...

sep 20
17 views

SELECT COUNT(*) AS user_count FROM Users WHERE Location L...

sep 20
16 views

SELECT id, displayname, location FROM users WHERE locatio...

sep 20
325 views

SELECT COUNT(*), MIN(CreationDate) AS min_date, MAX(Creat...

sep 20 jon.doe45746
325 views

SELECT COUNT(*), MIN(CreationDate) AS min_date, MAX(Creat...

sep 20 jon.doe45746
325 views

SELECT COUNT(*), MIN(CreationDate) AS min_date, MAX(Creat...

sep 20 jon.doe45746
16 views

SELECT Name AS name, COUNT(*) AS cnt FROM Badges GROUP BY...

sep 20
325 views

SELECT COUNT(*), MIN(CreationDate) AS min_date, MAX(Creat...

sep 20 jon.doe45746
30 views

3. Provide a leaderboard of users with correct answers who have commented on at least 10 unique pos

sep 20
29 views

3. Provide a leaderboard of users with correct answers who have commented on at least 10 unique pos

sep 20
11 views

SELECT COUNT(*) as user_cnt FROM Users WHERE Location LIK...

sep 20
325 views

SELECT COUNT(*), MIN(CreationDate) AS min_date, MAX(Creat...

sep 20 jon.doe45746
20 views

SELECT TOP 1 YEAR(CreationDate) AS year, MONTH(CreationDa...

sep 20
9 views

SELECT Id, DisplayName, Location FROM Users WHERE Locatio...

sep 20
17 views

SELECT TOP 1 YEAR(CreationDate) AS year, MONTH(CreationDa...

sep 20
30 views

title

sep 20
11 views

SELECT Location FROM Users WHERE Location LIKE '%NY%' OR ...

sep 20
19 views

SELECT YEAR(CreationDate) AS year, MONTH(CreationDate) AS...

sep 20
39 views

WITH PostCommentCounts AS ( SELECT p.Id AS PostId, COUNT(...

sep 20 sherman.ng
11 views

SELECT Location FROM Users WHERE Location LIKE '%NY%' OR ...

sep 20
10 views

SELECT format(CreationDate, 'yyyy-MM') AS year_month_form...

sep 20
19 views

SELECT format(CreationDate, 'yyyy-MM') AS year_month_form...

sep 20
17 views

SELECT format(CreationDate, 'yyyy-MM') AS year_month_form...

sep 20
20 views

SELECT format(CreationDate, 'yyyy-MM') AS year_month_form...

sep 20
16 views

SELECT format(CreationDate, 'yyyy-MM') AS year_month_form...

sep 20
16 views

SELECT format(CreationDate, 'yyyy-MM') AS year_month_form...

sep 20
17 views

SELECT format(CreationDate, 'yyyy-MM') AS year_month_form...

sep 20
17 views

SELECT format(CreationDate, 'yyyy-MM') AS year_month_form...

sep 20
17 views

SELECT format(CreationDate, 'yyyy-MM') AS year_month_form...

sep 20
17 views

SELECT format(CreationDate, 'yyyy-MM') AS year_month_form...

sep 20
11 views

SELECT Location FROM Users WHERE Location LIKE '%NY%'

sep 20
13 views

SELECT Location FROM Users

sep 20
34 views

Two people answered the same question

sep 20
31 views

Two people answered the same question

sep 20
30 views

Two people answered the same question

sep 20
12 views

SELECT Name as label_name, COUNT(*) label_cnt FROM Badges...

sep 20
230 views

Sherman Ng Question 1

sep 20 sherman.ng
15 views

SELECT Name as label_name, COUNT(*) as label_cnt FROM Bad...

sep 20
39 views

SELECT TOP 15 p.OwnerUserId, u.DisplayName AS OwnerDispla...

sep 20 sherman.ng
39 views

SELECT TOP 15 OwnerUserId, OwnerDisplayName, COUNT(Id) AS...

sep 20 sherman.ng
39 views

SELECT TOP 15 OwnerUserId, COUNT(Id) AS PostCount FROM Po...

sep 20 sherman.ng
11 views

SELECT Name as label_name, COUNT(*) as label_cnt FROM Bad...

sep 20
67 views

Sherman Ng Question 3

sep 20 sherman.ng

30 50 100 per page