0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people who build and repair bicycles, people who train cycling, or commute on bicycles

-- Best time to ask about NHibernate
-- Enter Query Description
SELECT TOP 20
    AVG(AnswerCount),
    CONVERT(varchar(40), CreationDate, 108)
FROM
    Posts
    INNER JOIN PostTags ON
        PostTags.PostId = Posts.Id
    INNER JOIN Tags ON
        Tags.Id = PostTags.TagId
WHERE
    Tags.TagName = 'nhibernate'
GROUP BY
    CONVERT(varchar(40), CreationDate, 108)
ORDER BY
    AVG(AnswerCount) DESC

fork query

created dec 6 10 anonymous