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
- 교차 엔트로피
- 깃헙협업
- full request
- RLIKE
- 편향-분산 교환
- Git
- 코딩공부
- early stopping
- L1정규화
- programmers
- 버전충돌
- coding
- mysql
- 선형 모형
- elastic net
- HTML
- AWS
- sql
- PYTHON
- leetcode
- 클라우드컴퓨팅
- hackerrank
- conflict
- github
- merge
- 온라인협업
- window function
- L2정규화
- CSS
- branch
Archives
- Today
- Total
Im between cherry
Hackerrank | MySQL | Revising the Select Query II 본문
Revising the Select Query II
Revising the Select Query II | HackerRank
Query the city names for all American cities with populations larger than 120,000.
www.hackerrank.com
Query the NAME field for all American cities in the CITY table with populations larger than 120000. The CountryCode for America is USA.
The CITY table is described as follows:
SOLUTION
SELECT NAME
FROM CITY
WHERE population > 120000 AND countrycode = 'USA'
'데이터분석 > practice_query' 카테고리의 다른 글
Hackerrank | MySQL |Japanese Cities' Names (0) | 2020.08.27 |
---|---|
Hackerrank | MySQL | Japanese Cities' Attributes (0) | 2020.08.27 |
Hackerrank | MySQL | Select By ID (0) | 2020.08.27 |
Hackerrank | MySQL | Select All (0) | 2020.08.27 |
Hackerrank | MySQL | Revising the Select Query I (0) | 2020.08.27 |
Comments