SELECT 
    p.year, 
    p.life_expect AS portugal_life_expectancy, 
    s.life_expect AS spain_life_expectancy, 
    s.alcohol AS spain_alcohol, 
    p.alcohol AS portugal_alcohol, 
    p.bmi AS portugal_bmi, 
    s.bmi AS spain_bmi
FROM 
    "@kaggle.mmattson_who_national_life_expectancy.who_life_exp" p
JOIN 
    "@kaggle.mmattson_who_national_life_expectancy.who_life_exp" s 
ON 
    p.year = s.year
WHERE 
    p.country = 'Portugal' AND 
    s.country = 'Spain'
ORDER BY 
    p.year;