select count([Answers].[Id]) as [Total Answers], count([Q...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Gardening and Landscaping Meta

Q&A about the site for gardeners and landscapers

-- Enter Query Title
-- Enter Query Description
select 
    count([Answers].[Id]) as [Total Answers],
    count([Questions].[Id]) as [Accepted Answers]
from
    [Posts] as [Answers]
    left outer join [Posts] as [Questions] on [Questions].[AcceptedAnswerId] = [Answers].[Id]
where
    [Answers].[PostTypeId] = 2 and
    [Answers].[OwnerUserId] = ##userid##

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results