SELECT x.year y, x.month m, 100 - cast(x.posts AS money)/...

0

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 x.year y, x.month m, 100 - cast(x.posts AS money)/cast(x1.posts AS money)*100 perc FROM 
(SELECT Year (CreationDate) year, Month (CreationDate) month, COUNT (PostTypeId) posts 
FROM Posts GROUP BY Year (CreationDate), Month (CreationDate)) x 
JOIN (SELECT Year (CreationDate) year, Month (CreationDate) month, Count (PostTypeId) posts 
FROM Posts GROUP BY Year (CreationDate), Month (CreationDate)) x1 
ON x.year =x1.year AND x.month - x1.month = 1 AND x.posts < x1.posts ORDER BY y,m;

Enter Parameters

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