Adam Lear
|
Registered User
|
- Select Count(*) From Posts p Inner Join PostTags pt On p....
- Select Id From Posts Where Tags Like '%wso2bi%'
- Most popular tags (all time)
- select top 10 * from Votes where VoteTypeId = 6
- select top 10 * from Votes where VoteTypeId = 6
- select top 10 * from PostHistory where PostHistoryTypeId ...
- Most viewed question in a given tag per year
- select count(*) from Users
- Number of users by age
- select count(*) from Posts q inner join Posts a on q.Id =...
- Questions that were once tagged "books"
- select distinct Score, PostId as [Post Link] from PostHis...
- select count(*) from Posts where AnswerCount = 0
- select a.Id as [Post Link], a.Tags, d.DisplayName, d.Repu...
- select top 100 v.id as voteid, p.id as [Post Link] from v...