SELECT petshop->location->city, petshop->location->state, count(*) as NumberYellow

FROM demo.pet

WHERE color = 'yellow' and type = 'bird'

GROUP BY petshop->location->city, petshop->location->state

ORDER BY NumberYellow desc