jon.doe45916
|
Registered User
|
- WITH UserAggregates AS ( SELECT Users.Id AS UserId, Users...
- WITH UserStats AS ( SELECT Users.Id AS UserId, COUNT(Post...
- 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(*) FROM PostTags JOIN Tags ON PostTags.TagId...
- SELECT COUNT(*) AS NumberOfPosts FROM Posts WHERE Creatio...
- SELECT COUNT(*) AS TotalPosts FROM Posts;
- SELECT U.Id AS UserId, U.DisplayName, U.Reputation, U.Cre...
- SELECT COUNT(DISTINCT p.OwnerUserId) AS UsersWithHighScor...
- SELECT COUNT(*) AS AboveAverageViewCountPosts FROM Posts ...
- SELECT COUNT(*) AS AboveAveragePosts FROM Posts WHERE Vie...