일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
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 |
- hackerrank
- 데이터분석
- 데이터시각화
- SQLite
- MySQL
- pandas
- solvesql
- SUM
- matplotlib
- SQL
- Round
- airflow 설치
- 머신러닝
- join
- airflow.cfg
- 데이터리안 웨비나
- TRUNCATE
- 전처리
- PostgreSQL
- Oracle
- 파이썬
- 다중 JOIN
- GROUPBY
- having
- 프로그래머스
- 결측값
- 그로스해킹
- Limit
- seaborn
- not in
- Today
- Total
목록Oracle (11)
Milky's note
https://www.hackerrank.com/challenges/weather-observation-station-1/problem?isFullScreen=true Weather Observation Station 1 | HackerRank Write a query to print the CITY and STATE for each attribute in the STATION table. www.hackerrank.com [문제] Query a list of CITY and STATE from the STATION table. The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the w..
https://www.hackerrank.com/challenges/japanese-cities-name/problem?isFullScreen=true Japanese Cities' Names | HackerRank In this challenge, you will query a list of all the Japanese cities' names. www.hackerrank.com [문제] Query the names of all the Japanese cities in the CITY table. The COUNTRYCODE for Japan is JPN. The CITY table is described as follows: [답] - oracle select name from city where ..
https://www.hackerrank.com/challenges/japanese-cities-attributes/problem?isFullScreen=true Japanese Cities' Attributes | HackerRank Query the attributes of all the cities in Japan. www.hackerrank.com [문제] Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japan is JPN. The CITY table is described as follows: [답] - oracle select * from city where countrycode = 'JPN';
https://www.hackerrank.com/challenges/select-by-id/problem?isFullScreen=true Select By ID | HackerRank Query the details of the city with ID 1661. www.hackerrank.com [문제] Query all columns for a city in CITY with the ID 1661. The CITY table is described as follows: [답] - oracle select * from city where ID = '1661';