Write a PSQL query to find the total count animals with "outcome
=Adopted" that has a higher age than the average age of all
animals.
Screenshot of data:
A B outcome animal_type age Adopted short_hair_cat Adopted short_hair_cat Adopted short_hair_cat Adopted short_hair_cat Adopted short_hair_cat Adopted short_hair_cat Adopted short hair cat D is_sterilize sex 0.2 No 0.2 No 1 Yes 1 No 0.1 No 1 Yes 02 Ves E F H number_a animals_ow age_adopter number_children_adopter salary_adopter 1 27 1 68939 2 28 1 93370 28 1 66253 28 1 61969 23 0 41715 23 2 52987 21 1 89339 Male Male Female Male Male Female Female 9836pm, 10 11 7 JOOON { 1 2
Write a PSQL query to find the total count animals with "outcome =Adopted" that has a higher age than the average age of
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am