SELECT * 
FROM `fao-maps.fao_zonal_stats_views.vw_chirps_daily` 
where system_time_start_week <= date_trunc(@filter_date, week) and
      system_time_start_week >= date_trunc(date_add(@filter_date, interval -120 day), week) 