LeetCode刷题#595

#595 Big Countries

1. Problem Description

There is a table World

A country is big if it has an area of bigger than 3 million square km or a population of more than 25 million.

Write a SQL solution to output big countries’ name, population and area.

For example, according to the above table, we should output:

2. My Codes

select name, population, area

from World

where area > 3000000 or population > 25000000

for mysql

3.Answers

1. same as my codes
2. use union , and faster