You are viewing a single comment's thread. Return to all comments →
HELLO https://www.hackerrank.com/elyazid_assouli
ABOVE CODE IS WRONG BECAUSE YOU ARE Comparing varchar with = operator .instead of = oprator you shoud use in oprator.
find correct code below.
SELECT name FROM city WHERE countrycode IN (SELECT code FROM country WHERE continent = 'Africa');
Seems like cookies are disabled on this browser, please enable them to open this website
African Cities
You are viewing a single comment's thread. Return to all comments →
HELLO https://www.hackerrank.com/elyazid_assouli
ABOVE CODE IS WRONG BECAUSE YOU ARE Comparing varchar with = operator .instead of = oprator you shoud use in oprator.
find correct code below.
SELECT name FROM city WHERE countrycode IN (SELECT code FROM country WHERE continent = 'Africa');