In class Activity

0

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

-- Counting users without complete profile information - - 
/*SELECT COUNT(*) AS 'Incomplete User Profiles' FROM Users
WHERE WebsiteUrl IS NULL OR Location IS NULL;*/

-- Identifying users with no questions asked in 2015 -- 
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);

Enter Parameters

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