SQLite Forum

Help with a query
Login
Below is my previous query updated to group rows by `pollDate` and to apply the aggregate function `sum()` on each of these groups:

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