일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
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 |
- window function
- 깃헙협업
- 편향-분산 교환
- AWS
- RLIKE
- L2정규화
- mysql
- 코딩공부
- hackerrank
- 온라인협업
- conflict
- CSS
- full request
- HTML
- coding
- 버전충돌
- elastic net
- leetcode
- L1정규화
- PYTHON
- programmers
- 교차 엔트로피
- early stopping
- github
- branch
- 선형 모형
- 클라우드컴퓨팅
- sql
- Git
- merge
- Today
- Total
목록데이터분석 (95)
Im between cherry
Draw The Triangle 1 Problem Higher Than 75 Marks | HackerRank Query the names of students scoring higher than 75 Marks. Sort the output by the LAST three characters of each name. www.hackerrank.com P(R) represents a pattern drawn by Julia in R rows. The following pattern represents P(5): Write a query to print the pattern P(20). SET @number:= 21; SELECT REPEAT('* ', @number := @number -1) FROM i..
Average Population of Each Continent Problem Average Population of Each Continent | HackerRank Query the names of all continents and their respective city populations, rounded down to the nearest integer. www.hackerrank.com Given the CITY and COUNTRY tables, query the names of all the continents (COUNTRY.Continent) and their respective average city populations (CITY.Population) rounded down to t..
African Cities Problem African Cities | HackerRank Query the names of all cities on the continent 'Africa'. www.hackerrank.com Given the CITY and COUNTRY tables, query the names of all cities where the CONTINENT is 'Africa'. Note: CITY.CountryCode and COUNTRY.Code are matching key columns. SELECT City.Name FROM City LEFT JOIN Country ON City.Countrycode = Country.Code WHERE Country.Continent = '..
Asian Population Problem Asian Population | HackerRank Query the sum of the populations of all cities on the continent 'Asia'. www.hackerrank.com Given the CITY and COUNTRY tables, query the sum of the populations of all cities where the CONTINENT is 'Asia'. Note: CITY.CountryCode and COUNTRY.Code are matching key columns. SELECT Sum(City.population) FROM City LEFT JOIN Country ON City.CountryCo..
Weather Observation Station 17 Problem Weather Observation Station 17 | HackerRank Query the Western Longitude for the smallest value of the Northern Latitudes greater than 38.7780 in STATION and round to 4 decimal places. www.hackerrank.com Query the Western Longitude (LONG_W)where the smallest Northern Latitude (LAT_N) in STATION is greater than . Round your answer to decimal places. SELECT RO..
Weather Observation Station 16 Problem Weather Observation Station 16 | HackerRank Query the smallest of STATION's Northern Latitudes that is greater than 38.7780, and round to 4 decimal places www.hackerrank.com Query the smallest Northern Latitude (LAT_N) from STATION that is greater than . Round your answer to decimal places. SELECT ROUND(MIN(LAT_N),4) FROM STATION WHERE LAT_N > 38.7780
Weather Observation Station 15 Problem Weather Observation Station 15 | HackerRank Query the Western Longitude for the largest Northern Latitude under 137.2345, rounded to 4 decimal places. www.hackerrank.com Query the Western Longitude (LONG_W) for the largest Northern Latitude (LAT_N) in STATION that is less than . Round your answer to decimal places. SELECT ROUND(LONG_W,4) FROM STATION WHERE ..
Weather Observation Station 14 Problem Weather Observation Station 14 | HackerRank Query the greatest value of the Northern Latitudes from STATION that are under 137.2345 and truncated to 4 decimal places. www.hackerrank.com Query the greatest value of the Northern Latitudes (LAT_N) from STATION that is less than . Truncate your answer to decimal places. SELECT TRUNCATE(MAX(LAT_N), 4) FROM STATI..