SQLZOO中case用法

SQLZOO题目:

Show the name and the continent - but substitute Eurasia for Europe and Asia; substitute America - for each country in North America or South America or Caribbean. Show countries beginning with A or B
（翻译：让你给出名字和所属地区的名字，
其中所属大洲的名字是Europe and Asia的改成Eurasia ,
其中所属大洲的名字是North America or South America or Caribbean的改成America ,
条件是国名的第一个字符是A or B）
答案：

 SELECT name,
       CASE WHEN continent in('Europe','Asia') THEN 'Eurasia'
            WHEN continent in('North America','South America','Caribbean') THEN 'America'
            ELSE continent END
  FROM world
 WHERE name LIKE 'A%' or name LIKE 'B%'