Questions and Answers per week

0

Please login or register to vote for this query.

(click on this box to dismiss)

Plot the site activity by voting, questions, answers and comments, aggregated per week.

Stack Overflow

Q&A for professional and enthusiast programmers

select qa.id as id ,qa.parentid as parentid, qa.a_body as body, qa.creationdate as date, c.text as bodycom
from (SELECT questions.Id as id, answers.parentid as parentid, questions.title,questions.body as q_body, answers.body as a_body, answers.creationdate
FROM Posts answers
INNER JOIN Posts questions ON answers.parentid = questions.id
WHERE questions.tags like '%microservices%'  and questions.tags like '%security%' and questions.tags like '%single-sign-on%'
and questions.tags like '%cloud%' and questions.tags like '%paas%')qa join comments c on qa.parentid = c.postid

Enter Parameters

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