MySQL NDB

0

Please login or register to vote for this query.

(click on this box to dismiss)

Signal Processing Meta

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%' COLLATE SQL_Latin1_General_CP1_CI_AS
AND
    Title like '%NBD%' 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')

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results