0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for committed Christians, experts in Christianity and those interested in learning more

with joined as 
(select PostTags.PostId, min(Tags.Count) as minimum
from PostTags 
left join Tags on PostTags.TagId = Tags.Id
group by PostTags.PostId
having min(Tags.Count)>50)

select count(distinct PostId)
from joined

fork query

edited aug 4 20

created aug 4 20 anonymous