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

SELECT *
FROM @kaggle.warcoder_dog_breeds_details.dog_breeds
JOIN @kaggle.marshuu_dog_breeds.dog_breeds 
ON @kaggle.warcoder_dog_breeds_details.dog_breeds.name = @kaggle.marshuu_dog_breeds.dog_breeds.breed
ORDER BY max_life_expectancy desc