1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

-- Number of comments thanking somebody

declare @totalcomments int
select @totalcomments = count(id) from comments

select
  'comments',
  count(Id) as [Count],
  count(Id) * 100.0 / @totalcomments as [Percentage]
from comments
where text like '%thank%';

fork query

created nov 12 10 sth