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