title: bigquery, is a "subtable" possible?
body: <p>In bigquery using legacy sql I have created a monstrous query that returns the following display of visits per day for a site that I released 2018-02-26:</p>
  
  <pre><code>Row  date       name    release_date  visits_count
  1    20180226   a_name  20180226      2179
  2    20180227   a_name  20180226      9522
  3    20180228   a_name  20180226      1593   
  4    20180301   a_name  20180226      300    
  ...
  </code></pre>
  
  <p>What I really want is</p>
  
  <pre><code>Row  name    release   count_release  count_release+1  count_release_rest
  1    a_name  20180226  2179           9522             1893  
  </code></pre>
  
  <p>Thus, I want the actual visit count for release date, the day after the release date and all counts after that should just be summed.
  I'm new to bigquery (and kind of new to sql...). Is there a way to define my first display as a "subtable" or something like that so that I can do this or what approach would you recommend?</p>