Number of Users with 1 rep

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

--count all users
select count(*) from users

--see all new users
select count(*) from users where reputation=1

--select users with one rep and have used the site after the first 24hrs
select count(*) from users where reputation=1 and ((select DATEDIFF(HOUR,CreationDate,LastAccessDate))>24);

--select users with one rep and have ONLY used the site during the first 24hrs (presumbly to see their first question's reception
select count(*) from users where reputation=1 and ((select DATEDIFF(HOUR,CreationDate,LastAccessDate))<24) and ((select DATEDIFF(SECOND,CreationDate,LastAccessDate))>0);

--select 'dead' users
select count(*) from users where reputation=1 and (CreationDate=LastAccessDate);

Enter Parameters

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