SELECT country, avg_le_birth, avg_hale_birth, avg_le_birth - avg_hale_birth as avg_no_full_health, round(100*((avg_le_birth - avg_hale_birth)/avg_le_birth),1) as rate_life_no_full_health, case when country = ${country_select} then 'select'
when country = ${country_select_compare} then 'compare' else 'other' end as color FROM "le_birth_per_country"