COUNT(*) answers 'how many rows?'

Instead of listing rows, you can ask for one number about them. COUNT(*) counts the rows that made it through your filters and hands back that single number. So the result is one row with one value, not a list.

SELECT COUNT(*)
FROM students;