A new townhouse called "Tulip" is being built that is "Pets-lite". Owners may keep dogs if the canine  in question is less than 20 lbs and has no complaints against it. Which dogs are eligible to move into
"Tulip"?

 

The data set is below.

 

First Name,Last Name,Breed,Weight,Age,Building,Complaints,Favorite Toy
Mottsy,Li,Rottweiler,101,5,Sunflower,0,Stuffy
Tramp,Li,Australian Cattle Dog,45,7,Sunflower,0,Stuffy
Wellesley,Onyewu,Chihuahua,8,2,Rose,5,Stuffy
Trevor,Tracy,Mexican Hairless,10,2,Vine,0,None
Ernesto,Gomez,Labrador,70,5,Vine,0,Ball
Che,Gomez,Golden Retriever,68,6,Vine,4,Ball
Pom Pom,Hartlock,Poodle,15,1,Rose,0,Ball
Killer,Nestle,Poodle,58,10,Sunflower,0,Stuffy
Fred,Hasselhoff,Chihuahua,7,2,Rose,0,Stuffy
Snooty,Barrata,Australian Cattle Dog,32,5,Rose,2,Ball
Blaze,Mastini,Chihuahua,5,13,Sunflower,4,Squeaky
Curly Cue,James,Poodle,16,1,Sunflower,1,Stuffy
Pog,Langdon,Labrador,81,8,Rose,0,Ball
Duckling,James,Labrador,62,3,Begonia,0,Ball
Taco,Sackler,Mexican Hairless,18,5,Sunflower,0,Stuffy
Nefrititi,Sackler,Labrador,68,2,Begonia,1,Stuffy
Bologna,Devidas,Chihuahua,10,10,Vine,0,Ball
Snorty,Harrison,Poodle,15,7,Vine,0,Ball
Chekov,Li,Labrador,68,4,Sunflower,1,Ball
Nester,Elmarte,Australian Cattle Dog,35,4,Sunflower,0,Squeaky
Toto,Chummings,Labrador,57,2,Rose,0,Squeaky

Answer rating: 100% (QA)

Answer Heres the SQL query to find eligible dogs sql SELECT FROM DogDataWHERE Weight 20 AND Complain... View the full answer