Answer
SELECT AVG (PetWeight) AS 'Avg_Weight'
FROM PET_3
GROUP BY PetWeight, PetBreed
HAVING COUNT (PetName) > 2
AND PetBreed != 'UNKNOWN'
Work Step by Step
N/A
Database Concepts
by Kroenke, David; Auer, David;
Published by
Pearson
ISBN 10:
0133544621
ISBN 13:
978-0-13354-462-6
Chapter 3 - Structured Query Language - Figure 3-19 - Pet Data - Page 214: 3.34
Update this answer!
You can help us out by revising, improving and updating this answer.
Update this answerAfter you claim an answer you’ll have 24 hours to send in a draft. An editor will review the submission and either publish your submission or provide feedback.
