1SELECT 
2    p.year, 
3    p.life_expect AS portugal_life_expectancy, 
4    s.life_expect AS spain_life_expectancy, 
5    s.alcohol AS spain_alcohol, 
6    p.alcohol AS portugal_alcohol, 
7    p.bmi AS portugal_bmi, 
8    s.bmi AS spain_bmi
9FROM 
10    "@kaggle.mmattson_who_national_life_expectancy.who_life_exp" p
11JOIN 
12    "@kaggle.mmattson_who_national_life_expectancy.who_life_exp" s 
13ON 
14    p.year = s.year
15WHERE 
16    p.country = 'Portugal' AND 
17    s.country = 'Spain'
18ORDER BY 
19    p.year;