0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for expert genealogists and people interested in genealogy or family history

SELECT COUNT(*) AS 'Users with no questions in 2015'
FROM Users As u
WHERE NOT EXISTS (
SELECT 1
FROM Posts AS p
WHERE p.OwnerUserId = u.Id
AND p.PostTypeId = (SELECT Id FROM PostTypes
WHERE Name = 'Question')
AND YEAR(p.CreationDate) = 2015);

fork query

created mar 29 anonymous