How many users have never voted

0

Please login or register to vote for this query.

(click on this box to dismiss)

Craft CMS Meta

Q&A about the site for administrators, end users, developers and designers for Craft CMS

--select count(*)
--from users
--where id not in (select id from votes)

WITH "VOTE-CTE" AS 
    (
    SELECT id FROM users
    EXCEPT
    SELECT userID FROM votes  
    )
SELECT COUNT(*)
FROM "VOTE-CTE"

Enter Parameters

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