Skip to content

This is a Leetcode database challenge. 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 an SQL query to report the name, population, and area of the big countries. Return the result table in any order. The query result format is in th…

Notifications You must be signed in to change notification settings

mercymugambi/leetcode-Big-Countries

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 

Repository files navigation

leetcode-Big-Countries challenge

This is a Leetcode SQL challenge.

The challenge is as follows.

part1 part2 part3

Upon going through the challenge, below is my code executed on phpmyAdmin database.

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

And this is the output to the solution simiral to the challenge output. yeah!

solution

Try it too

About

This is a Leetcode database challenge. 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 an SQL query to report the name, population, and area of the big countries. Return the result table in any order. The query result format is in th…

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published