Big Countries

You can write a MySQL query to find the name, population, and area of the big countries based on the given conditions (area of at least 3,000,000 km² or population of at least 25,000,000). Here’s the query:

1
2
3
SELECT name, population, area
FROM World
WHERE area >= 3000000 OR population >= 25000000;

The WHERE clause filters the rows based on the given conditions, selecting countries with an area greater than or equal to 3,000,000 km² or a population greater than or equal to 25,000,000.