Description
Write a SQL query to find countries with area >= 3000000 OR population >= 25000000. Return name, population, and area.
Table:
world| Column | Type |
|---|---|
| name | TEXT |
| continent | TEXT |
| area | INT |
| population | INT |
Examples
Input:
CREATE TABLE world (name TEXT, continent TEXT, area INT, population INT); INSERT INTO world VALUES ('Canada', 'North America', 9984670, 38000000), ('France', 'Europe', 640679, 67000000), ('Vatican', 'Europe', 1, 1000);Output:
Canada|38000000|9984670
France|67000000|640679Explanation:
Canada qualifies (area 9984670 >= 3000000). France qualifies (population 67000000 >= 25000000). Vatican fails both criteria.
Input:
CREATE TABLE world (name TEXT, continent TEXT, area INT, population INT); INSERT INTO world VALUES ('Russia', 'Asia', 17098242, 146000000), ('Brazil', 'South America', 8515767, 215000000), ('Monaco', 'Europe', 2, 39000);Output:
Russia|146000000|17098242
Brazil|215000000|8515767Explanation:
Russia qualifies because it meets both criteria (area >= 3000000 AND population >= 25000000). Brazil qualifies because it meets both criteria as well. Monaco fails both criteria (area = 2 < 3000000 AND population = 39000 < 25000000).
Input:
CREATE TABLE world (name TEXT, continent TEXT, area INT, population INT); INSERT INTO world VALUES ('Australia', 'Oceania', 7692024, 26000000), ('India', 'Asia', 3287263, 1380000000), ('Luxembourg', 'Europe', 2586, 634000);Output:
Australia|26000000|7692024
India|1380000000|3287263Explanation:
Australia qualifies by meeting both criteria. India qualifies because despite having area >= 3000000, it also has population >= 25000000 (meeting the OR condition). Luxembourg fails both criteria with small area and population.
Constraints
- •
Use OR in WHERE