In class SQL practice


Please login or register to vote for this query.

(click on this box to dismiss)

Latin Language

Q&A for linguists, teachers, and students wanting to discuss the finer points of the Latin language

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

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