title: Is it possible to get sum without change sql_mode?
body: <p>I have a problem to get <code>SUM</code> value from multiple table using join statement. The error is:</p>
  
  <blockquote>
    <p>this is incompatible with sql_mode=only_full_group_by</p>
  </blockquote>
  
  <p>Is it possible to get sum without change <code>sql_mode</code>? If possible, how to make a SQL statement to?</p>
  
  <p><strong>Table <code>fuel</code>:</strong></p>
  
  <pre><code>vehicle_id | liter
  -----------+-----------
           2 | 43.5
           4 | 78.3
           8 | 20.5
  </code></pre>
  
  <p><strong>Table <code>usage</code>:</strong></p>
  
  <pre><code>date_usage | vehicle_id
  -----------+-----------
  2019-10-01 |  8
  2019-10-15 |  2
  2019-10-20 |  8
  2019-10-20 |  4
  2019-11-02 |  8
  </code></pre>
  
  <p>The SQL statement is below:</p>
  
  <pre><code>SELECT fuel.vehicle_id, SUM(fuel.liter), usage.date_usage
  FROM fuel
  LEFT JOIN usage ON fuel.vehicle_id = usage.vehicle_id
  WHERE fuel.vehicle_id='8'
  AND usage.date_usage &gt;='2019-10-01' AND usage.date_usage &lt;='2019-10-31'
  GROUP BY fuel.vehicle_id
  </code></pre>