SELECT name, continent,
	case when continent='Oceania' then 'Australasia'
	when continent='Eurasia' or name = 'Turkey' then 'Europe/Asia'
	when continent='Caribbean' and name like 'B%' then 'North America'
	when continent='Caribbean' and name not like 'B%' then 'South America'
	else continent end
from world