SQLite Forum

Help with a query
Login
I see no column named `value` in your table.

Which column do you want to use for computing the sum?

So far, and if my guess machine is correctly tuned, if you're after half the sum of column `import` for all rows which `interval` is between 1 and 48, the translation into SQL is:

```
SELECT sum(import)/2.0
FROM Readings
WHERE interval BETWEEN 1 AND 48
```