SELECT ubicacion, COUNT(*) AS Ejemplares
FROM mascotas
WHERE estado='A'
GROUP BY Ubicacion
HAVING COUNT(*) BETWEEN 2 AND 3