AVG gives the average of a column

AVG adds up a column of numbers and divides by how many values there were — the average, worked out for you. It also turns many rows into one answer, so the result is a single number. Pair it with AS to give that number a clear heading.

SELECT AVG(pages) AS average_pages
FROM books;