How to Group List by Date?

[MALLORY8K]

How i can Grou List by Date?

[abraaoribeiro]

Hi see if it helps you, just replace the parameters.

 SELECT 
           CAST(strftime('%Y', dateTransaction) as INTEGER) as timestamp, 
          sum(classe.price) as total  
         FROM  
           expense 
         GROUP by 
           CAST(strftime('%Y', dateTransaction) as INTEGER);