sorry for not providing you with clear details. let try get them with some sample data as well

here it is in detail

select
referringdoctor, city,state,zip,count(distinct patientid) as cnt from nationaltable group by referringdoctor, city,state,zip--gave me for a specific doc 1000 cnt
referringdoctor, city,state,zip,referredto,count(distinct patientid) as...

Thank you for your suggestion

Thank you Jared.

Thank you will check

Thank you.

YES with couple of local recruiters but nobody seemed to be interested.