select count(t.y), count(t.m) from (select *, case when t...


Please login or register to vote for this query.

(click on this box to dismiss)

Portuguese Language

Q&A for linguists, teachers and learners wanting to discuss the finer points of the Portuguese language

select count(t.y), count(t.m) 
from (select *,
case when>=0 then '>=0' end as diff
from (select t.y as y, t.m as m, 
((lag(t.c) over (order by t.y, t.m))-t.c)*100/(lag(t.c) over (order by t.y, t.m)) 
as pr
from (select year(creationdate) as y, month(creationdate) as m, count(*) as c 
from posts group by year(creationdate), month(creationdate)) as t) as t) as t
where t.diff='>=0'

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results