select EXTRACT(month FROM create_date), count(*)
from anf_service_request
where demo_sr_flag = 0 and create_date between '01-SEP-2017' and '31-DEC-2017' and EXTRACT(year FROM create_date) in (2017)
group by EXTRACT(month FROM create_date);

SELECT  COUNT (*)
FROM anf_service_request
WHERE demo_sr_flag = 0 AND create_date  <='31-DEC-2017';

select EXTRACT(month FROM create_date), count(*)
from reg_device_registration
where create_date between '01-SEP-2017' and '31-DEC-2017' and EXTRACT(year FROM create_date) in (2017)
group by EXTRACT(month FROM create_date);

select count(*)
from reg_device_registration
where CREATE_DATE <= '31-DEC-2017';