I wouldn’t be able to give you sql for this. If a field can have different values the only way that I can think of to count each of the possible values is to
1) Do a query for all posts of the post type
2) Loop over each post
3) Get the field for each post
4) Loop over the values and count the ones that are selected
