In class Activity


Please login or register to vote for this query.

(click on this box to dismiss)

Project Management

Q&A for project managers

-- 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
                    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

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