How to calculate the sum of values ​​in a SQLite column?

Question

Python

Hello, I need to implement a table like this, the only question I have is how to implement the last row "total" so that the values ​​​​in it are recalculated when I add new records.
And how would it syntactically look like in python? Sorry for the possibly stupid question and thanks in advance for the replies.

Answer 1

cur.execute("SELECT SUM(count) FROM users")
result = cur.fetchone()[0]

Answer 2

You can talk to the base in its language , for example.
Or go over the data already by means of PL in recursion .