Two ways to be big: A country is big if it has an area of more than 3 million sq km or it has a population of more than 250 million.
Show the countries that are big by area or big by population. Show name, population and area.
select name, population, area from world WHERE ((population > 250000000) OR (area > 3000000))
AND NOT ((population > 250000000) AND (area > 3000000))
Harshal Jogi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
2
select name, population, area from world WHERE ((population > 250000000) OR (area > 3000000))
AND NOT ((population > 250000000) AND (area > 3000000)) and (population > 250000000) OR (area > 3000000)
Harshal Jogi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.