instruction: total sql questions and AcceptedAnswers my month.
response: WITH t1 AS (SELECT TIME_TO_STR(p.CreationDate, '%Y') AS Year, TIME_TO_STR(p.CreationDate, '%m') AS Month, COUNT(*) AS total, COUNT(AcceptedAnswerId) AS AcceptedAnswers FROM Posts AS p WHERE Tags LIKE '%<sql>%' GROUP BY TIME_TO_STR(p.CreationDate, '%Y'), TIME_TO_STR(p.CreationDate, '%m')) SELECT DATE(CONCAT(Year, '-', Month, '-01')), total, AcceptedAnswers FROM t1 ORDER BY 1