In class SQL practice

0

Please login or register to vote for this query.

(click on this box to dismiss)

Project Management

Q&A for project managers

SELECT COUNT(*) AS Users_Without_Questions_2015
FROM Users u
LEFT JOIN Posts p ON u.Id = p.OwnerUserId
LEFT JOIN PostTypes pt ON p.PostTypeId = pt.Id
WHERE YEAR(p.CreationDate) = 2015
    AND (pt.Name IS NULL OR pt.Name != 'Question');

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results