显示一系列日期的有效结果数

I currently have a table with a creation date and a expiry date. I currently have a sql command to get the number of valid items for a given date.I currently have a table with a creation date a