DECLARE @date1 date = '01-01-18'; DECLARE @date2 date = '...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Role-playing Games

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

DECLARE @date1 date = '01-01-18';
DECLARE @date2 date = '12-31-18';
select distinct count(DisplayName) from users 
  join posts 
  on users.Id = posts.OwnerUserId
  where posts.CreationDate < CAST('2018-01-01' AS DATE) or posts.CreationDate > CAST('2018-12-31' AS DATE)
-- between @date1 and @date2

Enter Parameters

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