What is the best way to count entries in the database?

Question

PHP

I have a table with applications, applications have a type. New, in work, completed. What is the best way to calculate them? Through COUNT query in sql? Or through a loop already in php? You need to count how many applications by type.

Answer 1

SELECT type, count(*)
FROM table_name
GROUP BY type