Total Inactive Users

0

Please login or register to vote for this query.

(click on this box to dismiss)

Where "inactive" is defined as "hasn't logged on in the past year".

Arts and Crafts Meta

Q&A about the site for artists and crafters

SELECT 
COUNT(Id) AS 'Total Users',
SUM(CASE WHEN LastAccessDate <= '2020-1-1' THEN 1 ELSE 0 END) AS 'Total Inactive'
FROM Users

Enter Parameters

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