def METHOD_NAME(start_date: str, end_date: str):
    query = f"""
        select c.corp_num, c.corp_type_cd, cn.corp_name, bd.naics_code, bd.description as naics_desc, c.recognition_dts, a.*
        from corporation c
                 join corp_name cn on cn.corp_num = c.corp_num
                 left outer join corp_processing cp on cp.corp_num = c.corp_num
                 join business_description bd on bd.corp_num = c.corp_num
                 join office o ON c.corp_num = o.corp_num
                 JOIN address a ON o.mailing_addr_id = a.addr_id
        where 
            c.recognition_dts between '{start_date}' and '{end_date}'
            and (a.addr_line_3 is not null and a.addr_line_3 <> '')
            and (cp.flow_name is null or cp.flow_name = 'test-etl')
            and (cp.processed_status = 'FAILED' or cp.processed_status is null)
        order by c.recognition_dts asc;
    """
    return query