My query looks like this en simplified form:
WHEN time BETWEEN 201905010000000 AND 201905312359999
WHEN time BETWEEN 201912010000000 AND 201912312359999
END AS Period,
Count (1) AS NumberOfSomething
GROUP BY Period
I would like to have a table returned with occurrences in '1905' (May) and 0 in '1912' (December) as there are no occurrences in December 2019 yet.