select C.country_name, C.region_id, R.region_name
From Countries C Join Regions R
on C.region_id = R.region_id
where R.region_id like '%2';