SELECT count(*) 'Number Of Students' //Count data result
FROM students
WHERE firstname = 'John' //Filter by name