title: Get Table and Count in each Table of dataset in BigQuery
body: <p>I want to understand how to get count of each table in dataset. I think I can get sum of counts in all tables by this query</p>
  
  <pre><code>SELECT count(*) FROM `DATASET.*`
  </code></pre>
  
  <p>How can I group it by each table and get the count?</p>