0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for practitioners of the art and science of signal, image and video processing

SELECT
count(Id) AS [id_count],
sum(viewCount) as [view_sum],
FORMAT(CreationDate, 'yyyy-MM')
FROM
    Posts
WHERE
    Title like '%mysql cluster%' COLLATE SQL_Latin1_General_CP1_CI_AS
AND
    CreationDate > '2019-01-01 00:00:00'
GROUP BY FORMAT(CreationDate, 'yyyy-MM')
ORDER BY FORMAT(CreationDate, 'yyyy-MM')

fork query

edited jan 20

created jan 20 anonymous