1--SELECT d1.name, d1.good_with_children, d1.good_with_other_dogs, d1.good_with_strangers, d2.age, d2.gender, d2.spayneuter
2--FROM @kaggle.warcoder_dog_breeds_details.dog_breeds d1
3--JOIN @kaggle.stealthtechnologies_predict_new_york_dog_bites.dog_bites_data d2 ON d1.name = d2.breed
4--WHERE d1.trainability > 3
5--ORDER BY max_life_expectancy asc
6
7SELECT d1.name, d1.good_with_children, d1.good_with_other_dogs, d1.good_with_strangers,
8       COUNT(d2.breed) AS breed_occurrences
9FROM @kaggle.warcoder_dog_breeds_details.dog_breeds d1
10JOIN @kaggle.stealthtechnologies_predict_new_york_dog_bites.dog_bites_data d2 ON d1.name LIKE ('%' || d2.breed || '%')
11WHERE d1.trainability > 3
12GROUP BY d1.name, d1.good_with_children, d1.good_with_other_dogs, d1.good_with_strangers
13ORDER BY breed_occurrences desc