counting the number of a specific word in one SQL column I'm trying to make a survey like a referundum to know if my neighboors in my small building are for or against a colectif compost to reduce the organics wastes.

For this tool vote I'm using PHP and SQL, my database is build like this:

DBNAME=collectifCompost
Table=voteCompost

column1=id PRIMARY AI     

column2=user

column3=vote(yes/no/blank)

To build a chart with statistics vote results (% of YES, NO, BLANK..) I want to make a query on my database to count the number of YES NO AND BLANK but I don't know how. Can you help me please?

If you need more information about my code ask me everything.
Use:

select   vote, count(*)
from     voteCompost
group by vote;


Now you get the number of rows per vote value.