select
    *
from
    project_requests
where
    fips_num IS NOT NULL
AND
    main LIKE '%\"type_of_rid\":\"\"%'
AND
    fips_date_new between to_date('01.06.2018', 'YYYY-MM-DD') AND to_date('15.06.2019', 'YYYY-MM-DD')