LeetCode/릿코드-Big Countries-MySQL

cosmos·2021년 9월 23일
0
post-thumbnail

문제

풀이

  • a country is big if it has an area of bigger than 3 million square km or a population of more than 25 million.
  • write a sql solution to output big countries name, popluation and area.
  • for example, according to the above table, we should output

쿼리

-- leetcode, Big Countries, mysql
SELECT name, population, area
FROM World
WHERE area >= 3000000 OR population >= 25000000

결과


출처 && 깃허브

leetcode
github

0개의 댓글