I must be thinking of the wrong thing with your suggestion of in-line view.

select A.FNAM, A.LNAM, A.CITY, B.STATE, B.CNTRY, A.SNAM, A.STATE, COUNT(A.STATE)
*
ERROR at line 1:
ORA-00937: not a single-group group function


SQL>
I added COUNT(A.STATE) to the select in orig note and got the same message that I keep getting.... not a single group function. I must STILL be barking up the wrong tree. NOTE, the -- in original note had gotten this same error when I tried them also.