SELECT COUNT(p.Id) 'Number of Question by Mat Mannion' FR...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu Meta

Q&A about the site for Ubuntu users and developers

SELECT COUNT(p.Id) 'Number of Question by Mat Mannion'
FROM Users u, Posts p, PostTypes pt
WHERE u.Id = p.OwnerUserId AND p.PostTypeId = pt.Id
AND LOWER(u.DisplayName) = 'mat mannion'
AND LOWER(pt.Name) = 'question';

Enter Parameters

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