SELECT petshop->location->city, petshop->location->state, count(*) as NumberYellow
FROM demo.pet
WHERE %NOINDEX color = 'yellow' and %NOINDEX type = 'bird'
GROUP BY petshop->location->city, petshop->location->state
ORDER BY NumberYellow desc