Query: Dog Breed by Claudia

1SELECT d1.*, d2.*
2FROM @kaggle.warcoder_dog_breeds_details.dog_breeds d1
3JOIN @kaggle.marshuu_dog_breeds.dog_breeds d2 ON d1.name = d2.breed
4ORDER BY max_life_expectancy desc

name	min_life_expectancy	max_life_expectancy	max_height_male	max_height_female	max_weight_male	max_weight_female	min_height_male	min_height_female	min_weight_male	min_weight_female	good_with_children	good_with_other_dogs	shedding	grooming	drooling	coat_length	good_with_strangers	playfulness	protectiveness	trainability	energy	barking	breed	country_of_origin	fur_color	height_in	color_of_eyes	longevity_yrs	character_traits	common_health_problems
Coton de Tulear	15	19	11	11	15	13	10	10	9	8	5	5	2	4	1	1	5	4	3	4	3	1	Coton de Tulear	Madagascar	White	9-11	Brown	12-14	Intelligent, energetic, playful, good-natured	Dental problems, skin allergies, hip dysplasia
Shih Tzu	10	18	10.5	10.5	16	16	9	9	9	9	5	5	1	4	1	1	3	3	3	4	3	3	Shih Tzu	China	Black, White, Brown	9-10	Brown	10-16	Affectionate, playful, confident, good-natured	Dental problems, respiratory issues, eye problems
Xoloitzcuintli	13	18	25	25	60	60	19	19	28	28	3	3	1	1	1	1	3	4	3	4	4	3	Xoloitzcuintli	Mexico	Black, Red	10-14	Brown	12-15	Intelligent, energetic, playful, good-natured	Dental problems, eye issues, skin allergies
Chihuahua	14	16	8	8	6	6	5	5	4	4	1	3	2	1	1	2	2	4	4	3	4	5	Chihuahua	Mexico	Black, Brown, Tan, White	6-9	Brown, Blue	12-20	Loyal, energetic, confident, sensitive	Dental problems, eye issues, respiratory issues
Dachshund	12	16	9	9	32	32	8	8	16	16	3	4	2	2	2	2	4	4	4	4	3	5	Dachshund	Germany	Black, Tan	5-9	Brown, Blue	12-15	Loyal, energetic, playful, curious	Intervertebral disc disease, hip dysplasia, diabetes
Pomeranian	12	16	7	7	7	7	6	6	3	3	3	3	2	3	1	1	3	3	4	3	3	4	Pomeranian	Germany	Orange, Sable, Black	6-7	Brown	12-16	Playful, energetic, intelligent, good-natured	Dental problems, eye problems, obesity
Belgian Malinois	14	16	26	26	80	60	24	24	60	40	3	3	3	2	1	1	3	3	4	5	4	3	Belgian Malinois	Belgium	Fawn, Mahogany	22-26	Brown	12-14	Intelligent, energetic, loyal, protective	Hip dysplasia, eye problems, skin allergies
Papillon	14	16	11	11	10	10	8	8	5	5	5	3	3	2	1	1	5	5	4	5	4	5	Papillon	France	White, Black, Sable, Red	8-11	Brown	14-16	Intelligent, energetic, affectionate, good-natured	Dental problems, eye problems, bladder stones
Australian Cattle Dog	12	16	20	20	50	50	18	18	35	35	3	3	3	1	1	1	3	3	4	4	5	1	Australian Cattle Dog	Australia	Blue, Red	17-20	Brown	12-16	Intelligent, energetic, playful, good-natured	Dental problems, skin allergies, hip dysplasia
Australian Cattle Dog	12	16	20	20	50	50	18	18	35	35	3	3	3	1	1	1	3	3	4	4	5	1	Australian Cattle Dog	Australia	Blue, Red	17-20	Brown	12-14	Intelligent, energetic, good-natured, loyal	Dental problems, eye issues, skin allergies
Miniature Pinscher	12	16	12.5	12.5	10	10	10	10	8	8	3	4	3	1	1	1	3	4	5	3	5	5	Miniature Pinscher	Germany	Red, Stag Red	10-12	Brown	12-14	Intelligent, energetic, playful, good-natured	Dental problems, eye issues, skin allergies
Beagle	10	15	16	15	20	30	14	13	15	20	5	5	3	2	1	1	3	4	2	3	4	4	Beagle	England	White, Tan, Red, Lemon	13-15	Brown	12-15	Curious, friendly, energetic, good-natured	Ear infections, hip dysplasia, epilepsy
Pug	13	15	13	13	18	18	10	10	14	14	5	4	4	2	1	1	5	5	3	4	3	1	Pug	China	Fawn, Black	10-14	Brown	12-15	Loyal, playful, affectionate, social, charming	Eye problems, respiratory issues, obesity
Bichon Frise	14	15	11.5	11.5	18	18	9.5	9.5	12	12	5	5	1	5	1	1	5	4	2	4	4	3	Bichon Frise	France	White	9-11	Brown	12-15	Playful, affectionate, intelligent, social	Dental problems, eye problems, bladder stones
Australian Shepherd	12	15	23	23	65	55	20	20	50	40	5	3	3	2	1	1	3	4	3	5	5	3	Australian Shepherd	Australia	Black, Red	18-23	Brown, Blue	12-15	Intelligent, energetic, loyal, trainable	Hip dysplasia, eye problems, epilepsy
Irish Setter	12	15	27	27	70	60	27	27	70	60	5	5	3	3	2	1	5	5	3	4	5	3	Irish Setter	Ireland	Red	24-28	Brown	12-15	Intelligent, energetic, good-natured, affectionate	Hip dysplasia, eye problems, cancer
West Highland White Terrier	13	15	11	11	20	20	11	11	15	15	5	3	3	3	1	1	4	5	5	3	4	5	West Highland White Terrier	Scotland	White	11-12	Brown	12-16	Intelligent, energetic, playful, good-natured	Dental problems, skin allergies, hip dysplasia
Pug	13	15	13	13	18	18	10	10	14	14	5	4	4	2	1	1	5	5	3	4	3	1	Pug	China	Black, Fawn	10-14	Brown	12-15	Intelligent, energetic, playful, good-natured	Dental problems, respiratory issues, eye problems
American Eskimo Dog	13	15	26	26	65	65	24	24	45	45	5	3	3	3	1	1	5	3	3	4	4	3	American Eskimo Dog	United States	White	15-19	Brown	12-15	Intelligent, energetic, playful, good-natured	Dental problems, skin allergies, hip dysplasia
Border Collie	12	15	22	22	55	55	19	19	30	30	3	3	3	3	1	1	4	5	3	5	5	4	Border Collie	England	Black, White, Red	18-22	Brown	12-15	Intelligent, energetic, playful, good-natured	Dental problems, eye issues, skin allergies
Australian Shepherd	12	15	23	23	65	55	20	20	50	40	5	3	3	2	1	1	3	4	3	5	5	3	Australian Shepherd	Australia	Blue Merle	20-23	Brown	12-14	Intelligent, energetic, good-natured, loyal	Dental problems, eye issues, skin allergies
Australian Shepherd	12	15	23	23	65	55	20	20	50	40	5	3	3	2	1	1	3	4	3	5	5	3	Australian Shepherd	Australia	Black, Red	18-23	Brown	12-15	Intelligent, energetic, playful, good-natured	Dental problems, skin allergies, hip dysplasia
Cardigan Welsh Corgi	12	15	12.5	12.5	38	34	10.5	10.5	30	25	4	3	3	2	1	1	4	4	3	4	4	5	Cardigan Welsh Corgi	Wales	Red, Sable, Black	10-12	Brown	12-14	Intelligent, energetic, playful, good-natured	Dental problems, eye issues, skin allergies
Giant Schnauzer	12	15	27.5	27.5	85	75	25.5	25.5	60	55	3	3	3	4	2	1	3	4	5	5	5	3	Giant Schnauzer	Germany	Black, Salt & Pepper	25-28	Brown	10-12	Loyal, intelligent, good-natured, energetic	Dental problems, eye issues, skin allergies
Irish Setter	12	15	27	27	70	60	27	27	70	60	5	5	3	3	2	1	5	5	3	4	5	3	Irish Setter	Ireland	Red	26-28	Brown	12-14	Intelligent, energetic, playful, good-natured	Dental problems, eye issues, skin allergies
Irish Terrier	13	15	18	18	27	25	18	18	27	25	5	1	2	1	1	1	3	3	5	3	3	3	Irish Terrier	Ireland	Red	14-16	Brown	12-14	Intelligent, energetic, playful, good-natured	Dental problems, eye issues, skin allergies
Italian Greyhound	14	15	15	15	14	14	13	13	7	7	3	5	3	1	1	1	5	4	3	4	3	3	Italian Greyhound	Italy	Red, Black	13-15	Brown	12-15	Intelligent, energetic, playful, good-natured	Dental problems, eye issues, skin allergies
Keeshond	12	15	18	18	45	45	18	18	35	35	5	5	3	3	2	1	5	5	5	5	4	4	Keeshond	Netherlands	Black, Cream	17-19	Brown	12-15	Intelligent, energetic, playful, good-natured	Dental problems, eye issues, skin allergies
Maltese	12	15	9	9	8.8	8.8	7	7	6.6	6.6	3	3	1	4	1	1	3	3	4	3	3	3	Maltese	Malta	White	8-10	Brown	12-15	Intelligent, energetic, playful, good-natured	Dental problems, eye issues, skin allergies
West Highland White Terrier	13	15	11	11	20	20	11	11	15	15	5	3	3	3	1	1	4	5	5	3	4	5	West Highland White Terrier	Scotland	White	10-12	Brown	12-15	Intelligent, energetic, playful, good-natured	Dental problems, eye issues, skin allergies
Whippet	12	15	22	22	40	40	19	19	25	25	5	5	2	1	1	1	3	4	3	3	4	1	Whippet	England	White, Black, Red	18-22	Brown	12-15	Intelligent, energetic, good-natured, loyal	Dental problems, eye issues, skin allergies
Yorkshire Terrier	11	15	8	8	7	7	7	7	7	7	5	3	1	5	1	1	5	4	5	4	4	4	Yorkshire Terrier	England	Blue & Tan	7-8	Brown	12-15	Intelligent, energetic, playful, good-natured	Dental problems, eye issues, skin allergies
Siberian Husky	12	14	23.5	23.5	60	50	21	21	45	35	5	5	4	2	1	1	5	5	1	3	5	5	Siberian Husky	Russia	Black, White	21-24	Blue	12-15	Independent, energetic, intelligent, playful, strong	Hip dysplasia, eye problems, hereditary myopathy
Cocker Spaniel	10	14	15.5	15.5	30	25	14.5	14.5	25	20	5	5	3	4	2	1	4	3	3	4	4	3	Cocker Spaniel	England	Black, Brown	14-15	Brown	12-15	Affectionate, intelligent, energetic, good-natured	Ear infections, hip dysplasia, eye problems
Pekingese	12	14	9	9	14	14	6	6	7	7	3	3	3	3	1	1	3	4	4	3	3	1	Pekingese	China	Black, White, Red	6-9	Brown	12-15	Independent, intelligent, affectionate, good-natured	Dental problems, respiratory issues, eye problems
Borzoi	9	14	33	31	105	85	30	27	75	60	3	3	3	2	1	1	3	3	3	2	4	2	Borzoi	Russia	White, Cream, Red	26-29	Brown	10-12	Gentle, good-natured, loyal, intelligent	Dental problems, eye issues, skin allergies
Shetland Sheepdog	12	14	16	16	25	25	13	13	15	15	5	5	3	3	1	1	2	5	5	5	4	5	Shetland Sheepdog	Scotland	Sable, Black	13-16	Brown	12-14	Intelligent, energetic, playful, good-natured	Dental problems, eye issues, skin allergies
Staffordshire Bull Terrier	12	14	16	16	38	34	14	14	28	24	5	3	2	2	3	1	4	4	5	5	4	3	Staffordshire Bull Terrier	England	White, Black, Red	14-16	Brown	12-14	Intelligent, energetic, playful, good-natured	Dental problems, eye issues, skin allergies
Vizsla	12	14	24	24	60	55	22	22	55	44	5	4	3	2	2	1	4	5	3	5	5	3	Vizsla	Hungary	Red	20-24	Brown	12-14	Intelligent, energetic, playful, good-natured	Dental problems, eye issues, skin allergies
Akita	10	14	28	28	130	100	26	26	100	70	3	1	3	3	1	1	2	3	5	3	4	2	Akita	Japan	Red, Fawn, Sesame	24-28	Brown	10-12	Loyal, intelligent, good-natured, energetic	Dental problems, eye issues, skin allergies
Basenji	13	14	17	17	24	22	17	17	24	22	3	3	2	1	1	1	3	3	3	2	4	1	Basenji	Congo	Red, Black & White	16-17	Brown	12-15	Intelligent, energetic, playful, good-natured	Dental problems, eye issues, skin allergies
Cocker Spaniel	10	14	15.5	15.5	30	25	14.5	14.5	25	20	5	5	3	4	2	1	4	3	3	4	4	3	Cocker Spaniel	England	Black, Brown	14-15	Brown	12-15	Intelligent, energetic, playful, good-natured	Dental problems, eye issues, skin allergies
Samoyed	12	14	23.5	23.5	65	50	21	21	45	35	5	3	3	3	1	1	5	5	4	4	4	5	Samoyed	Russia	White	21-23	Brown	12-14	Intelligent, energetic, playful, good-natured	Dental problems, eye issues, skin allergies
Basset Hound	12	13	15	14	65	65	12	11	40	40	5	5	2	3	4	1	3	3	3	3	2	4	Basset Hound	France	Black, Tan	11-15	Brown	10-12	Affectionate, patient, gentle, good-natured	Dental problems, ear infections, obesity
Greyhound	10	13	30	30	70	65	28	28	65	60	3	4	2	1	1	1	3	3	3	3	4	3	Greyhound	England	Black, White, Brindle	26-30	Brown	10-12	Intelligent, athletic, sensitive, good-natured	Hip dysplasia, eye problems, heart conditions
Boston Terrier	11	13	17	17	25	25	15	15	12	12	5	4	2	2	1	1	5	5	3	4	4	2	Boston Terrier	United States	Black, White	15-17	Brown	11-13	Intelligent, energetic, affectionate, good-natured	Eye problems, respiratory issues, skin allergies
Basset Hound	12	13	15	14	65	65	12	11	40	40	5	5	2	3	4	1	3	3	3	3	2	4	Basset Hound	France	Black, White, Red	11-15	Brown	10-12	Gentle, good-natured, loyal, intelligent	Dental problems, eye issues, skin allergies
Bull Terrier	12	13	22	22	70	70	21	21	50	50	3	1	3	2	1	1	4	4	3	3	4	3	Bull Terrier	England	White, Red	20-22	Brown	10-12	Loyal, intelligent, good-natured, energetic	Dental problems, eye issues, skin allergies
Field Spaniel	12	13	18	18	50	50	18	18	35	35	5	4	3	2	2	1	4	3	3	5	3	3	Field Spaniel	England	Black, Liver	15-18	Brown	12-14	Intelligent, energetic, playful, good-natured	Dental problems, eye issues, skin allergies
Greyhound	10	13	30	30	70	65	28	28	65	60	3	4	2	1	1	1	3	3	3	3	4	3	Greyhound	England	White, Black, Red	26-30	Brown	10-12	Intelligent, energetic, good-natured, loyal	Dental problems, eye issues, skin allergies
Labrador Retriever	10	12	24.5	24.5	80	70	22.5	22.5	65	55	5	5	4	2	2	1	5	5	3	5	5	3	Labrador Retriever	Canada	Yellow, Black, Chocolate	21-24	Brown	10-12	Loyal, friendly, intelligent, energetic, good-natured	Hip dysplasia, obesity, ear infections
Boxer	10	12	25	25	80	65	23	23	65	50	5	3	2	2	3	1	4	4	4	4	4	3	Boxer	Germany	Fawn, Brindle	21-25	Brown	10-12	Loyal, energetic, intelligent, playful, protective	Hip dysplasia, cancer, heart conditions
Golden Retriever	10	12	24	24	75	65	23	23	65	55	5	5	4	2	2	1	5	4	3	5	3	1	Golden Retriever	Scotland	Golden	21-24	Brown	10-12	Intelligent, friendly, kind, loyal, good-natured	Hip dysplasia, cancer, skin allergies
French Bulldog	10	12	13	13	28	26	11	11	20	18	5	4	3	1	3	1	5	5	3	4	3	1	French Bulldog	France	White, Black, Brindle	11-12	Brown	10-12	Affectionate, playful, good-natured	Breathing problems, eye problems, hip dysplasia
Great Pyrenees	10	12	32	32	120	90	27	27	110	80	3	3	3	2	3	1	3	3	5	3	3	3	Great Pyrenees	France	White	25-32	Brown	10-12	Loyal, intelligent, gentle, protective	Hip dysplasia, cancer, skin allergies
Doberman Pinscher	10	12	28	28	100	90	26	26	75	60	5	3	4	1	2	1	4	4	5	5	5	3	Doberman Pinscher	Germany	Black, Red	24-28	Brown	10-12	Loyal, energetic, intelligent, protective	Hip dysplasia, heart conditions, cancer
Rhodesian Ridgeback	10	12	27	27	85	70	25	25	85	70	5	3	3	2	2	1	3	3	5	4	3	2	Rhodesian Ridgeback	Rhodesia	Light Wheaten	25-27	Brown	10-12	Intelligent, athletic, loyal, good-natured	Hip dysplasia, eye problems, cancer
Bloodhound	10	12	27	27	110	100	25	25	90	80	3	3	3	2	5	1	3	3	2	4	3	5	Bloodhound	England	Red, Black	22-27	Brown	10-12	Loyal, intelligent, good-natured, energetic	Dental problems, eye issues, skin allergies
American Bulldog	10	12	28	24	100	80	20	20	75	60	3	3	2	0	0	1	0	0	0	4	0	1	American Bulldog	United States	White, Red	20-28	Brown	10-12	Loyal, intelligent, good-natured, energetic	Dental problems, eye issues, skin allergies
Cane Corso	9	12	27.5	27.5	110	99	25	25	99	88	3	3	2	1	3	1	3	3	5	4	4	3	Cane Corso	Italy	Black, Red	22-28	Brown	10-12	Loyal, intelligent, good-natured, energetic	Dental problems, eye issues, skin allergies
Golden Retriever	10	12	24	24	75	65	23	23	65	55	5	5	4	2	2	1	5	4	3	5	3	1	Golden Retriever	Scotland	Gold	21-24	Brown	12-14	Intelligent, energetic, playful, good-natured	Dental problems, eye issues, skin allergies
Japanese Chin	10	12	11	11	11	11	8	8	7	7	3	5	3	2	1	1	3	3	3	3	3	2	Japanese Chin	Japan	Black, Red	7-11	Brown	12-15	Intelligent, energetic, playful, good-natured	Dental problems, eye issues, skin allergies
Great Dane	7	10	32	32	175	140	30	30	140	110	3	3	3	1	4	1	3	4	5	3	4	3	Great Dane	Germany	Black, Blue, Fawn, Harlequin	28-34	Brown	8-10	Gentle, loyal, intelligent, good-natured	Hip dysplasia, cancer, heart conditions
Newfoundland	9	10	28	28	150	120	28	28	130	100	5	5	3	2	5	1	5	3	5	3	3	1	Newfoundland	Canada	Black, Brown, Grey	26-28	Brown	9-11	Loyal, intelligent, gentle, good-natured	Hip dysplasia, heart conditions, cancer
Rottweiler	9	10	27	27	135	100	24	24	95	80	3	3	3	1	3	1	3	4	5	5	3	1	Rottweiler	Germany	Black, Tan	22-27	Brown	8-10	Loyal, protective, confident, strong	Hip dysplasia, cancer, elbow dysplasia