title: How to query the latest table using Standard Query
body: <p>In Legacy SQL, I found this syntax very useful to query the latest table from the set of tables with Date Suffix.</p>
  
  <pre><code>SELECT * 
  FROM 
  TABLE_QUERY([project_id:dataset], 
    'table_id = (SELECT MAX(table_id) 
                 FROM [project_id:dataset.__TABLES__]  
                 WHERE table_id CONTAINS "tablename_2016")
    ')
  </code></pre>
  
  <p>so, If I have set of tables such as <code>tablename_20161205, tablename_20161206, tablename_20161219</code>, the query will find the latest table which is tablename_20161219 in this case and I don't need to look through all tables and specify the latest one. </p>
  
  <p>How do I achieve this in Standard SQL? 
  Thx so much.</p>