How to implement counting the number of elements with a specific SQL value?

Question

SQL

I have the following table
. For each element, I need to display its count with the active status.
I tried to implement this using this query: SELECT name, COUNT(status='active') FROM docs GROUP BY name
but in this case all fields are considered.
Please tell me what is wrong and how to fix it

Answer 1

SUM(status='active')