AsheeshR
|
Registered User
|
- SELECT 100*M.#/N.# as '%Total', Comment , N.m, N.y FROM (
- SELECT 100*M.#/N.# as '%Total', Comment , N.m, N.y FROM (
- SELECT * FROM VoteTypes
- SELECT DATEDIFF(dd, CreationDate, ClosedDate) as '#DaysOp...
- SELECT DATEDIFF(dd, CreationDate, ClosedDate) as '#DaysOp...
- SELECT Users.Id, count(Posts.Id) FROM Users, Posts WHERE ...
- SELECT count(*) as 'Posts', -DATEDIFF(day, ClosedDate, Cr...
- SELECT count(*) as 'Posts', -DATEDIFF(day, ClosedDate, Cr...
- SELECT count(*) as 'Posts', -DATEDIFF(day, ClosedDate, Cr...
- SELECT Id, PostTypeID, Body FROM Posts WHERE PostTypeId =...
- SELECT * FROM Posts WHERE DATALENGTH(Body)<20
- SELECT count(Badges.Id), Users.Id FROM Badges, Users WHER...
- SELECT count(Badges.Id) FROM Badges, Users WHERE Badges.U...
- SELECT count(Badges.Id) FROM Badges, Users WHERE Badges.U...
- SELECT avg(CommentCount) FROM Posts WHERE PostTypeId = 1