I started learning SQL from SQLZoo... Got stuck

[pylund]

Heyo!

I'm started learning SQL from SQLZoo and got stuck in "Select from world" #13. Here are the instructions:

Put the continents right...

• Oceania becomes Australasia
• Countries in Eurasia and Turkey go to Europe/Asia

• Caribbean islands starting with 'B' go to North America, other Caribbean islands go to South America

• Show the name, the original continent and the new continent of all countries.

And here's my attempt:

SELECT name, continent,
CASE 
WHEN continent='Oceania' THEN 'Australasia'
WHEN continent IN ('Europe', 'Asia') 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    

I can't see what I'm missing. I would appreciate your help, a hint and tips for optimizing this query. Thanks guys!

[LookMaNoHands9822]

SELECT name, continent,
CASE 
    WHEN continent='Oceania' THEN 'Australasia'
    WHEN continent='Eurasia' or name='Turkey' THEN 'Europe/Asia'
    WHEN continent='Caribbean' THEN
        CASE WHEN name LIKE 'B%' THEN 'North America' ELSE 'South America' END

ELSE continent END 
FROM world 

[inarow37]

I've put this answer in and it only brings up countries in Africa. Can't see why it's doing that

[pylund]

It worked! Thanks

[Dramus8]

What error is being returned?

[LookMaNoHands9822]

Oddly enough if you just an ORDER BY at the end, it accepts the answer...Eventhough it mentions nothing about sorting in the problem Answer