title: How to put together the results of functions of several tables in one query?
body: <p>I have two tables, for example ONE and TWO, my tables are bigger and with different structures, but have some fields that coincide.</p>
  
  <p><img src="https://i.stack.imgur.com/iatVU.jpg" alt="enter image description here"></p>
  
  <p>How can I get the table QUERY?</p>
  
  <p>I can do it with just one table WITH GROUP and SUM, but how can I add the last column in QUERY? Is it possible?</p>
  
  <pre><code>SELECT Date, SUM(Apples), SUM(Oranges) FROM One
  GROUP BY Date
  </code></pre>