0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for speakers of other languages learning English

with optjava as (
Select PostId
from PostTags
where TagId = 5 or TagId = 42
group by PostId
having count(*) = 2)
select id as [Post Link],
       AcceptedAnswerId,
       Score,
       CreationDate,
       AnswerCount
from Posts inner join optjava on Id = PostId
where ClosedDate is null
  and Score > 0
order by Score Desc

view current version

edited sep 15 15

created jan 17 14 rolfl