This is my first time using SQL. So, go easy on me :)
I'm executing these queries on some websites online where there is an already made database with Country name,Area,Population,etc
What I would like to do is, to get the names of all the countries in Asia or Africa that starts with 'A' and their population > 40000
I think my nesting is wrong. Isn't it possible to make more than 2 nesting in SQL?
SELECT name, area, population FROM world WHERE name IN (SELECT name FROM world WHERE continent = 'Asia' OR continent = 'Africa' ) IN (SELECT name FROM world WHERE name LIKE 'A%') IN (SELECT name FROM world WHERE population > 50000 )