Skip to content

Latest commit

 

History

History
45 lines (31 loc) · 802 Bytes

097_big_countries.md

File metadata and controls

45 lines (31 loc) · 802 Bytes

SQL Everyday #097

Big Countries

Site: LeetCode
Difficulty per Site: Easy

Problem

A country is big if:

  • it has an area of at least three million (i.e., 3000000 km2), or
  • it 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.

Return the result table in any order. [Full Description]

Submitted Solution

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

Site Solution

-- LeetCode Solution 
-- Site solution essentially the same.

Notes

TODO

Go to Table of Contents
Go to Overview