0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for users of TeX, LaTeX, ConTeXt, and related typesetting systems

SELECT COUNT(*) AS 'users with no questions in 2015'
FROM users AS u
WHERE NOT EXISTS (
    SELECT 1
    FROM posts AS ps
    WHERE ps.OwnerUserID = u.ID
    AND ps.PostTypeID = (SELECT ID FROM posttypes WHERE name = 'questions')
    AND YEAR(ps.creationDate) = 2015
);

fork query

edited mar 30

created mar 30 anonymous