jon.doe45916
|
Registered User
|
- WITH UserAggregates AS ( SELECT Users.Id AS UserId, Users...
- SELECT Users.Id, DisplayName FROM Users WHERE Users.Id IN...
- WITH UserStats AS ( SELECT Users.Id AS UserId, COUNT(Post...
- WITH UserStats AS ( SELECT Users.Id AS UserId, COUNT(Post...
- WITH UserAggregates AS ( SELECT Users.Id AS UserId, SUM(C...
- SELECT Users.Id AS UserId, Users.DisplayName, Users.LastA...
- SELECT Users.Id AS UserId, Users.DisplayName, Users.Reput...
- SELECT u.Id AS UserId, u.DisplayName, u.Reputation, u.Cre...
- SELECT COUNT(*) AS UsersJoined FROM Users WHERE YEAR(Crea...
- SELECT COUNT(*) AS NumberOfPosts FROM Posts WHERE YEAR(Cr...
- Select * from Posts where CommentCount >= 4;
- SELECT COUNT(DISTINCT u.Id) AS UsersWithoutComments FROM ...
- SELECT COUNT(*) FROM PostTags JOIN Tags ON PostTags.TagId...
- SELECT COUNT(*) FROM PostsWithDeleted WHERE CreationDate ...
- SELECT COUNT(*) FROM PostHistory WHERE CreationDate >= '2...