Number of questions/answers/comments per day for the past 6 months

0

Please login or register to vote for this query.

(click on this box to dismiss)

Poker Meta

Q&A about the site for serious players and enthusiasts of poker

select  c.Text comment,
        DATEADD(day,0,DATEDIFF(day,0,c.CreationDate)) comment_date
into    #coms
from    Comments c 
where   c.CreationDate > '09/06/19'

select  comment_date,
        sum(case when 
        comment LIKE '%[^a-zA-Z0-9][Jj]ust[^a-zA-Z0-9]%'
        then 1 else 0 end) just,
        count(comment) total
into    #coms_type
from    #coms
group by comment_date

select  comment_date,
        just / (total * 1.0) just_pct
from    #coms_type
order by comment_date

Enter Parameters

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