MySQL查询w / COUNT（）和HAVING基于日期比较

I am trying to limit my count results to those that meet a specific criteria. I am currently using a WHERE clause and my output is as expected.I am trying to limit my count results to those