June 23, 2017 African Cities | SQL:- Hackerrank Given the CITY and COUNTRY tables, query the names of all cities where the CONTINENT is 'Africa'. Note: CITY.CountryCode and COUNTRY.Code are matching key columns. Input Format The CITY and COUNTRY tables are described as follows: Query: select city.name. from city INNER JOIN country ON city.countrycode=country.code where continent='Africa'; Share this:Click to share on Twitter (Opens in new window)Click to share on Facebook (Opens in new window)Click to share on Google+ (Opens in new window)MoreClick to share on LinkedIn (Opens in new window)Click to share on WhatsApp (Opens in new window)Click to email this to a friend (Opens in new window)Click to print (Opens in new window)Like this:Like Loading... Related Related Posts Fraudulent Activity Notifications Day 5: Loops Asian Population | SQL About The Author admin Add a Comment Cancel reply Your email address will not be published. Required fields are marked *Comment:*Name:* Email Address:* Website: Notify me of follow-up comments by email. Notify me of new posts by email.