Plot the site activity by voting, questions, answers and comments, aggregated per week.
Q&A for professional and enthusiast programmers
select qa.id as id , 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.id = c.postid