Posted on September 3, 2020September 3, 2020 Description Submission SELECT NAME FROM CITY INNER JOIN ( SELECT CODE FROM COUNTRY WHERE CONTINENT='Africa' ) AS AFRICAN_COUNTRY ON CITY.COUNTRYCODE=AFRICAN_COUNTRY.CODE; By Bill0412 HackerRank SQL