Don't abbreviate ane USE INNER JOIN please

SQL Queries Assume the following relational schema for a Pet Adoption Agency: ANIMAL (ID, Name, Type, PrevOwner_SSN, DateAdmitted) ADOPTER (SSN, Name, Address) ADOPTION (Animal_ID, SSN, AdoptionDate, TagNo) Write in SQL the following queries: 1. List the adopters of animals of type parrots. 2. List the dogs and their previous owners (name and address). Dogs are in the agency and are not yet adopted. 3. List the adopters (name and address) of at least one cat and one dog 4. List the number of cats that were adopted and their adopters live in Riyadh. 5. List per type the number animals that were adopted 6. List the adopters who are adopting cats but not dogs