Development of 'reinstate' usernames


Please login or register to vote for this query.

(click on this box to dismiss)

Anime and Manga

Q&A for anime and manga fans

with a as (
   select convert(decimal(12,0),CreationDate) CDate,
             When OwnerDisplayname like '%Reinstate%' collate SQL_Latin1_General_CP1_CI_AS
             Then 1
             Else 0
          End Reinstate
   from Posts
   where PostTypeId = 2

select 7*round(CDate / 7,0),Reinstate,Count(CDate) from a
group by 7*round(CDate / 7,0), Reinstate
order by 7*round(CDate / 7,0)

Enter Parameters

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