Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation
with singleton as (select min(c.Id) Id from comments c join posts p on (PostId = p.Id) group by PostId having count(*) = 1 ) select top 100 s.Id as [Comment Link] --len(text)/15, count(*) from singleton s join comments c on (s.Id = c.Id) where score is null --group by len(text)/15 order by newid()