Comentarios con @

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow en español

Preguntas y respuestas para programadores y profesionales de la informática

WITH CantPorMes AS (
  select DateAdd(month, DateDiff(month, 0, CreationDate), 0) as Mes,
         Sum(case when Text like '%@%' then 1 else 0 end) as Arrobados,
         Count(*) as Total
  from Comments
  group by DateAdd(month, DateDiff(month, 0, CreationDate), 0)
)

select Mes,
       Round(100.0*Arrobados/Total,2) as [Porcentaje Arrobados]
from CantPorMes
where Mes >= '2019-01-01'
order by Mes

Enter Parameters

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