We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
Loading...
  1. Practice
  2. SQL
  3. Basic Join
  4. African Cities
  5. Discussions

African Cities

Sort 93 Discussions, By:

votes

  • alexbelenov + 1 comment

    MySQL The first:

    Select City.Name From City Inner Join Country 
On CountryCode = Code
Where Continent = 'Africa';

    The second:

    Select City.Name From City, Country
Where Code = CountryCode And Continent = 'Africa';

    The third:

    Select Name From City Where CountryCode In (
    Select Code From Country Where Continent = 'Africa'
);

  • xyu_1 + 0 comments

    And add the MS SQL to all tests

  • zymawy + 1 comment

    My Solution For MySQL WithOut JOIN 

    SELECT city.name FROM city WHERE countrycode IN (SELECT code FROM country WHERE continent = "africa");
    • erenis_lemus + 0 comments

      DOESNT WORK

  • marinskiy + 0 comments

    Here is Oracle solution from my HackerrankPractice repository:

    SELECT CITY.NAME
FROM CITY
JOIN COUNTRY ON CITY.COUNTRYCODE = COUNTRY.CODE
WHERE CONTINENT = 'Africa';

    Feel free to ask if you have any questions :)

  • kau96kim + 0 comments
    SELECT
    c2.name
FROM    
    Country AS c1
INNER JOIN
    City AS c2
    ON  c1.code=c2.countrycode
WHERE
    c1.continent='Africa'

  • salmanashahab + 0 comments

    SELECT CITY.NAME FROM CITY JOIN COUNTRY ON CITY.COUNTRYCODE = COUNTRY.CODE WHERE CONTINENT = 'Africa';

  • msubhadip05 + 0 comments

    select city.name from city, country where continent='Africa' and CITY.CountryCode = COUNTRY.Code;

  • knlsharma + 0 comments
    SELECT city.name FROM city WHERE countrycode IN (SELECT code FROM country WHERE continent = "africa");

  • simple_guitar99 + 0 comments

    MSSQL with nested select :

    select name from city where countrycode in(select code from country where continent ='africa')

  • variadarshil + 0 comments

    MYSQL select city.name from city, country where CITY.CountryCode = COUNTRY.Code AND Country.continent = 'Africa';

Load more conversations