The COUNT aggregate function counts the number of rows in a table. Try:

SELECT COUNT(*) FROM characters;