title: Sqlite query to gets sum values of hours time bands
body: <p>I have this table :</p>
  <pre><code>------------------------------------   
  DATEHOUR         | FRUITS
  ------------------------------------ 
  2020-11-24 00:00 | 10 
  2020-11-24 00:15 | 10 
  2020-11-24 01:00 | 30
  2020-11-24 01:15 | 10 
  2020-11-24 02:00 | 30
  2020-11-24 02:15 | 10 
  2020-11-25 00:00 | 30
  2020-11-25 00:15 | 10 
  2020-11-25 01:00 | 30
  2020-11-25 01:15 | 10 
  2020-11-25 02:00 | 30
  2020-11-25 00:15 | 10 
  ------------------------------------
  </code></pre>
  <p>I need to calculate the SUM of FRUITS each DAYS grouped by bands, the first band (B1) is between 00:00 AND 01:00 , the sencond (B2) is between 01:15 AND 02:00</p>
  <pre><code>DAY        | B1  | B2  
  ------------------------
  2020-11-24 | 50  | 60 
  2020-11-25 | 40  | 80 
  </code></pre>
  <p>Is it possible to do this with a simple SQL query ? I'm using SQLITE</p>
  <p>Thanks</p>