Consider that you are given a database of a 'Pet Society' with the following relations.
Animals(ID: integer, Name: string, PrevOwner: string, DateAdmitted: date. Type: string)
Adopter(PSIN: integer, Name: string, Address: string, OtherAnimals: integer)
Adoption(AnimalID: integer, PSIN: integer, AdoptDate: date, chipNo: integer)
Give a sql query that list total number of adoptions on June 30, 2024 for each animal type.