Plot the site activity by voting, questions, answers and comments, aggregated per week.
Q&A for professional and enthusiast programmers
select res.id as id , res.bodycom as body , res.datecom as date from(select qa.q_id as id ,qa.a_id as a_id, qa.a_body as body, qa.creationdate as date, c.text as bodycom, c.creationdate as datecom
from (SELECT questions.Id as q_id, answers.id as a_id, 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.a_id = c.postid) res