1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for folks dedicated to a lifestyle that can be maintained indefinitely without depleting available resources

-- Questions with most answers
-- 

with
a as (
  select * from posts where PostTypeId = 2
),
q as (
  select * from posts where POstTypeId = 1
)

select top 25
  count(a.Id) as [Answer Count],
  q.Id as [Post Link]
from q, a
where
   q.Id = a.ParentId
group by q.Id
order by [Answer Count] desc;

fork query

created aug 8 10 anonymous