Section-A: Subject Related QuestionsAnswer the following questions (1-15)

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.

Created: 3 months ago | Updated: 3 months ago

Related Questions