Page 1 of 1

Write a PSQL query to find the total count animals with "outcome =Adopted" that has a higher age than the average age of

Posted: Mon Jun 06, 2022 1:08 pm
by answerhappygod
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:
Write A Psql Query To Find The Total Count Animals With Outcome Adopted That Has A Higher Age Than The Average Age Of 1
Write A Psql Query To Find The Total Count Animals With Outcome Adopted That Has A Higher Age Than The Average Age Of 1 (28.95 KiB) Viewed 23 times
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