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

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

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

Post 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 21 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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply