返回在一段时间内每天创建、关闭和打开的记录数量

I have a table that stores creation and closure dates. What I'm trying to do is run a query that gives me in a given time period, for each day, how many records were created, how many were closed, and how many were open. Table structure:I have a table that stores creation and closure