SQLite Forum

Help with a query
Login
Hi, I am ok with the simplest of queries but I am no expert with creating complex one, I am guessing
that the type of query I want is an easy one for those in the know. 

I am after a query that would get the sum(column value) from a table that records intervals based 
on subset (interval) of a number between 1 to 48 

i.e select aDate, sum(column) as v, sum(v / 2) as c 
	where interval between 15 and 22 order by aDate; 

the result I am after is something like 

aDate			 v		 c
---------------------------------------------
2020/01/01  	        234   	        117  
2020/01/02		187		93.5
2020/01/03		340		170

I have tried a couple of things but have only been able to get a single row for one day with the answer I am after

I do not have enough experience to work out what to do to get the result, any help would be appreciated, I will learn from the contributions.

Hope I have given enough info.

Cheers