instruction: Count of received votes per month.
response: SELECT CAST(CAST(TIME_TO_STR(v.CreationDate, '%Y') AS TEXT(4)) + '-' + CAST(TIME_TO_STR(v.CreationDate, '%M') AS TEXT(2)) + '-01' AS DATETIME) AS "date", COUNT(CASE v.VoteTypeId WHEN 1 THEN 1 END) AS "accept", COUNT(CASE v.VoteTypeId WHEN 2 THEN 1 END) AS "up", COUNT(CASE v.VoteTypeId WHEN 3 THEN 1 END) AS "down" FROM Votes AS v INNER JOIN Posts AS p ON p.Id = v.PostId WHERE p.OwnerUserId = '##user##' GROUP BY CAST(CAST(TIME_TO_STR(v.CreationDate, '%Y') AS TEXT(4)) + '-' + CAST(TIME_TO_STR(v.CreationDate, '%M') AS TEXT(2)) + '-01' AS DATETIME) ORDER BY Date