Species Ratio
###
Stat Charts
###
Any rev01
###
The species ratio of animals entering the shelter between two dates.
###
en
###
SELECT s.SpeciesName, COUNT(a.ID) AS Species
FROM animal a
INNER JOIN species s ON s.ID = a.SpeciesID
WHERE a.DateBroughtIn >= '$ASK DATE Enter the from date$' AND a.DateBroughtIn <= '$ASK DATE Enter the to date$'
AND NonShelterAnimal = 0
GROUP BY s.SpeciesName
ORDER BY s.SpeciesName
###
GRAPH PIE
