title: BigQuery - exclude exclude records with certain values
body: <p>I'd like to exclude records with certain values. For example, I don't want the BridgeTokens with appName A. Then count the remaining BridgeTokens (Row 2,6,7) grouped by appName.  How to do that in BigQuery? 
  The table is:</p>
  
  <pre><code>Row   BridgeToken   appName
  1     ffffff1       A 
  2     ffffff2       B 
  3     ffffff3       C
  4     ffffff3       B
  5     ffffff3       A
  6     aaaaaa4       C
  7     bbbbbb2       B
  </code></pre>
  
  <p>The result from my query is not accurate.:</p>
  
  <pre><code>SELECT
      COUNT(bridgeToken) AS Bridges,
      appName
    FROM
      `&lt;DB&gt;`
    WHERE NOT BridgeToken IN (
       SELECT DISTINCT BridgeToken 
       FROM `&lt;DB&gt;` 
       WHERE appName IN("A")
      AND date &lt; "2018-05-01 00:00:00"
      AND date &gt;= "2018-04-01 00:00:00")
    GROUP BY
      appName 
  ORDER BY
    Bridges DESC
  </code></pre>
  
  <p>Thanks in advance.</p>