Download the world-x database from the following MySQL website: http://dev.mysql.com/doc/index-other.html (Links to an external site.)Links to an external site.

Using the world_x database you installed in Module 1, list the countries and the capitals of each country. Modify your query to limit the list to those countries where less than 30% of the population speaks English. Be sure to identify the literary sources you used to look up any SQL syntax you used to formulate your query.

I am having issues with this I need the capital city name, not the code use the city table for this. select country.name and city.name once joined the tables on the country.capital and the city.ID

Someone help me fix my code please

select * from city;

SELECT CountryCodecountry.NAME,country.Capital FROM country INNER JOIN countrylanguage ON country.Code =

countrylanguage.CountryCode WHERE countrylanguage.Language =

"English" AND countrylanguage.Percentage < 30;