title: bigQuery throws "division by zero: 0 / 0" error
body: <p>I am doing the percentage by the frequency of column value using bigquery. However, some of the value might be zero, so the query will return error for sure</p>
  <pre><code>(division by zero: 0 / 0)
  </code></pre>
  <p>How to apply kind of IFERROR(x/y,null) in this case? so the query will bounce null value as the result instead of error?</p>
  <pre><code>SELECT 
      User_ID, 
     ROUND(SUM(CASE WHEN Name LIKE '%MIKE%' THEN 1 ELSE 0 END) / COUNT(Name) * 100 ,1) AS Percentage_of_MIKE,
      
  FROM
    table
  GROUP BY 
    User_ID
  </code></pre>
  <p>TRIED:</p>
  <pre><code>ROUND(SAFE_DIVIDE(SUM(CASE WHEN Name LIKE '%MIKE%' THEN 1 ELSE 0 END) / COUNT(Name) * 100 ,1)) AS Percentage_of_MIKE,
  </code></pre>