Well, as there is no date like 2014, you would expect null, because the maximum of nothing is actually not anyting.
But do this:
COALESCE(MAX(number),0)
Which means: get the first non-null thing from the next list, so if your max
is null, it'll give you 0