查询某个时间段每天的记录数

表结构：
create table info_record(
id varchar2(40) primary key,
name varchar2(40),
description varchar2(255),
record_time date
);


查询的sql语句：
select count(info_record_set.id) 
from (
select id,to_char(record_time,'yyyy-mm-dd') as record_time_char
from info_record 
where record_time >= to_date('2017-09-05','yyyy-mm-dd')
      and record_time <= to_date('2018-01-03','yyyy-mm-dd')
) info_record_set
group by record_time_char