595. Big Countries

Topic link

595. Big Countries

Subject analysis

This is an SQL problem.

The name, population and area of a country with an area of more than 3 million square kilometers or a population of more than 25 million is required to be returned.

Train of thought

The land area is greater than 3 million square kilometers: area>3000000

Population over 25 million: population>25 million

Select name, population, area

The final code

# Write your MySQL query statement below
select name, population,area from world
where area>3000000 or population>25000000;
Copy the code

If you find this article useful, you are welcome to subsidize it with love.