0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people who love being outdoors enjoying nature and wilderness, and learning about the required skills and equipment

select top 100 posts.id, posts.body, cast( posts.creationDate as date), sum(posts.ViewCount), count(comments.id)
from posts
left outer join comments on(posts.id = comments.postid)

group by posts.id, posts.body, posts.creationDate

fork query

edited jun 20 18

created jun 20 18 anonymous