SQLite - how to get average value?

Question

Hi, I have in my table a column that has values of type FLOAT. How can I get average value of all elements in this column?

Thank you in advance.

Answer 1

SELECT AVG(column) FROM ...

Answer 2

select avg(column) from table;

Answer 3

select avg(col1) from table;

Answer 4

select avg( columnname) from table;

This will average all rows. To average a subset, use a where clause. To average for each group (of something) use a group by clause.