title: Bigquery if null and 0 then condition
body: <p>I would like to add a condition if the row value is null or 0 then 0 else 1.</p>
  <pre><code>SELECT CASE WHEN NUM_FRIEND IS NULL AND 0 THEN 0 ELSE 1 END AS friends_column
  FROM TABLE
  </code></pre>
  <p>I get the following error:</p>
  <pre><code>No matching signature for operator and 
  </code></pre>