My table survey.dbf have fields: course and state

I need to see the result of the survey

I start by using the course name and state as below:

count for course = "refrigeration" and state = "SP"
count for course = "refrigeration" and state = "PR"

But as I have many states, and not sure if all states exist, I would like to have a command that group all states,
so I do not need to worry about states

T.I.A

Moises