Q3

0

Please login or register to vote for this query.

(click on this box to dismiss)

Meta Stack Exchange

Q&A about the Stack Exchange Network

/*Select Count(p.Id) As [Posts], pt.Name As [Type], u.DisplayName As [Name] 
From Posts p
Inner Join Users u
On p.OwnerUserId = u.Id
Inner Join PostTypes pt
On pt.Id = p.PostTypeId
Where u.DisplayName = 'Mat Mannion' And pt.Name = 'Question'
Group By  pt.Name, u.DisplayName*/

Select Count(*) 
From Posts p
Left Join Users u
On p.OwnerUserId = u.Id
/*Left Join PostTypes pt
On p.PostTypeId = p.Id*/
Where u.DisplayName like 'Mat Mannion' And p.PostTypeId = (Select Id From PostTypes Where Name like 'Question')

Enter Parameters

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