Using Audience in AEP's Query Service

@crv_555 You will have profile snapshot datasets created for each merge policy on the sandbox and these profile snapshots gets refreshed on daily basis post global segment eval. you can get write your own query to filter all profile in that snapshot as per your business need

Sample query to to find count by audience, you can tune this as per your corresponding audience id

1) https://experienceleague.adobe.com/docs/experience-platform/dashboards/query.html?lang=en#count-of-profiles-by-audience

2) Capturing output of query results can be done in couple of ways, check the link below

https://experienceleague.adobe.com/docs/experience-platform/query/ui/create-datasets.html?lang=en#generate-datasets-with-a-pre-defined-experience-data-model-schema