Q&A for professional and enthusiast programmers
Select p.id as [Post Link], p.title, p.tags, p.viewcount, p.score, p.commentcount, p.answercount, p.favoritecount, p.creationDate, p.lastactivitydate, count(distinct c.UserId) as uniquecommenter from Posts p join Comments c on p.id = c.postid where p.Tags like '%##Tag?amazon-dynamodb##%' AND Body like '%dynamodb%mapper%' and body like '%java%v2%' group by p.id, p.title, p.tags, p.viewcount, p.score, p.commentcount, p.answercount, p.favoritecount, p.creationDate, p.lastactivitydate order by p.viewcount desc