Notice
Recent Posts
Recent Comments
Link
일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | 5 | ||
6 | 7 | 8 | 9 | 10 | 11 | 12 |
13 | 14 | 15 | 16 | 17 | 18 | 19 |
20 | 21 | 22 | 23 | 24 | 25 | 26 |
27 | 28 | 29 | 30 | 31 |
Tags
- 서버설정
- 처음 만나는 AI 수학 with Python
- iterator
- 병합
- 목록처리
- 친절한SQL튜닝
- 데비안
- network configuration
- 티스토리 쿠키 삭제
- 구멍가게코딩단
- 페이징
- 선형대수
- Kernighan의 C언어 프로그래밍
- 이터레이터
- 스프링 시큐리티
- 스프링부트핵심가이드
- 네트워크 설정
- resttemplate
- 코드로배우는스프링웹프로젝트
- 자바편
- 깃
- GIT
- /etc/network/interfaces
- 리눅스
- 알파회계
- 자료구조와 함께 배우는 알고리즘 입문
- 코드로배우는스프링부트웹프로젝트
- merge
- 자료구조와함께배우는알고리즘입문
- 처음 만나는 AI수학 with Python
Archives
- Today
- Total
bright jazz music
595. Big Countries 본문
https://leetcode.com/problems/big-countries/
+-------------+---------+
| Column Name | Type |
+-------------+---------+
| name | varchar |
| continent | varchar |
| area | int |
| population | int |
| gdp | int |
+-------------+---------+
name is the primary key column for this table.
Each row of this table gives information about the name of a country, the continent to which it belongs, its area, the population, and its GDP value.
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 the following example.
Example 1:
Input:
World table:
+-------------+-----------+---------+------------+--------------+
| name | continent | area | population | gdp |
+-------------+-----------+---------+------------+--------------+
| Afghanistan | Asia | 652230 | 25500100 | 20343000000 |
| Albania | Europe | 28748 | 2831741 | 12960000000 |
| Algeria | Africa | 2381741 | 37100000 | 188681000000 |
| Andorra | Europe | 468 | 78115 | 3712000000 |
| Angola | Africa | 1246700 | 20609294 | 100990000000 |
+-------------+-----------+---------+------------+--------------+
Output:
+-------------+------------+---------+
| name | population | area |
+-------------+------------+---------+
| Afghanistan | 25500100 | 652230 |
| Algeria | 37100000 | 2381741 |
+-------------+------------+---------+
---
solution :
# Write your MySQL query statement below
select name, population, area from World where area >= 3000000 or population >= 25000000;
---
This is a basic problem. But I record here because it is meaningful as a start.
'LeetCode > SQL' 카테고리의 다른 글
183. Customers Who Never Order (0) | 2022.11.26 |
---|---|
584. Find Customer Referee (0) | 2022.11.26 |
1757. Recyclable and Low Fat Products (0) | 2022.11.26 |
Comments