title: BigQuery Subtract Counts of Two Tables?
body: <p>In MySQL I can do <code>SELECT (SELECT COUNT(*) FROM table1) - (SELECT COUNT(*) FROM table2)</code> to get the difference in counts between two tables. When I try this in BigQuery, I get: <code>Subselect not allowed in SELECT clause</code>. How do I run a query like this in BigQuery?</p>