For Last 1 month most rescued you need to check/filter all the animals that have come in shelter in last month and get the count for those animals and then get the animal with max row counts.
and Same with 1 month most fostered animals, you need to filter the animals with date of foster in last month and get the count of tows for those animals and from that get the max value to find the most fostered animal.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.