How do you select records by date and add values in sqlite?

MIT App Inventor Help
1

How to select records by date and add values ​​in sqlite?

I need to determine which records are within a date range and sum the values ​​of the records that are within that date range

Example data:
image
For example, I need to know the sum of the values ​​between the dates 02/04 and 03/04

2

I would store my dates like this 2024-03-20....(probably as a string not a date number)

Once you have your queried records returned, as a list, you can iterate over these to "add values".