Paulo Diogo
|
Registered User
|
Researcher |
- select CAST (CreationDate AS DATE), case when ClosedDate ...
- select top 100 * from Posts where PostTypeId = 1 -- quest...
- select * from Posts where PostTypeId = 1 -- question and ...
- select * from Posts where PostTypeId = 1 -- question and ...
- Score médio zero
- select CAST (CreationDate AS DATE), avg(score) from Posts...
- select UserId, count(distinct PostId) from PostHistory wh...
- Usuarios SOpt (verificando usuários ativos) draft 1
- Perguntas abertas
- Perguntas fechadas
- SELECT top 100 Tags.TagName, COUNT(*) AS [Number of assoc...
- select Q.Id as [Post Link] from Posts Q where Q.Score = -...
- select Q.Id as [Post Link] from Posts Q
- SELECT Q.Score, count(Q.Id) FROM Posts Q WHERE Q.AnswerCo...
- Count questions without accepted answer marked per tag count