일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
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 |
- Git
- 깃헙협업
- hackerrank
- L2정규화
- coding
- L1정규화
- RLIKE
- 코딩공부
- PYTHON
- 교차 엔트로피
- conflict
- github
- 버전충돌
- 선형 모형
- window function
- merge
- leetcode
- 클라우드컴퓨팅
- early stopping
- sql
- branch
- CSS
- 온라인협업
- elastic net
- programmers
- HTML
- full request
- 편향-분산 교환
- mysql
- AWS
- Today
- Total
목록데이터분석/practice_query (83)
Im between cherry
Select All Problem Select All | HackerRank Query all columns for every row in a table. www.hackerrank.com Query all columns (attributes) for every row in the CITY table. The CITY table is described as follows: SOLUTION SELECT * FROM city
Revising the Select Query II Problem 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 popu..

Revising the Select Query I Problem Query all columns for all American cities in the CITY table with populations larger than 100000. The CountryCode for America is USA. The CITY table is described as follows: Solution SELECT * FROM city WHERE population > 100000 AND countrycode = 'USA'