0 of 50 solved/50

595. Big Countries

SQL 50 · Select (day 1). Decode it with the hints, solve it on LeetCode, then compare with the reference solution in MySQLPostgreSQL.

Your work

Status Notes Your solution (MySQLPostgreSQL)

Open one at a time. Try to finish with as few as you can.

1. What does one output row represent?

One country.

2. Approach

WHERE with OR on the area and population conditions.

3. The trap

Use >= exactly as the statement says.

Tested on MySQL 8.0 and PostgreSQL 16. Switch dialect at the top of the page.

Show the MySQLPostgreSQL solution

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