I want to know the count(*) when alternativedeal = 'Null'. But my query returns 0, it should be give me the result of 'Number 30. How could I fix it? Thanks.
and cast(submittedtimestamp as date) between '2015-04-01' and '2015-04-30'
and alternativedeal = 'Null'