LeetCode 595: Big Countries
Solving LeetCode 595: Big Countries Explained
I'm Varchasv, a Data Engineer working on enterprise data integration.
Currently on a 90-problem challenge to level up my technical skills and switch to a more development-focused role.
What I'm doing:
- Solving 2 Leetcode problems daily (SQL + DSA).
- Blogging about each problem.
- Building in public.
My Goal - Land a better data engineering role by mid-2026.
Follow my journey !!
Date: January 28, 2026
Category: SQL
Time Taken: 1 minute
Difficulty: Easy
Problem Statement
A country is big if:
it has an area of at least three million (i.e.,
3000000 km²), orit has a population of at least twenty-five million (i.e.,
25000000).
Write a solution to find the name, population, and area of the big countries.
Link: Big Countries
My Approach
It is a very basic problem that only needs WHERE clause with a condition. Just do >= both numbers and you are done.
Solution Code
SELECT name, population, `area`
FROM World
WHERE `area` >= 3000000 OR population >= 25000000
Key Takeaway: Nothing, very easy problem.
Pattern: Filter
Mistakes I Made: None
Series: 90 Days of Data Engineering Progress: 23/90 problems completed
Tags: #DEQuest #LeetCode #SQL #DataEngineering #BuildInPublic