title: filtering the expression before creating an array with array_agg
body: <p>Is there any way to filter the data inside the content of an </p>
  
  <blockquote>
    <p>array_agg</p>
  </blockquote>
  
  <p>in one step, without writing a CTE to filter the content first?</p>
  
  <p><a href="https://cloud.google.com/bigquery/docs/reference/standard-sql/arrays" rel="nofollow noreferrer">https://cloud.google.com/bigquery/docs/reference/standard-sql/arrays</a></p>