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';