일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
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 |
- github
- full request
- L2정규화
- AWS
- 깃헙협업
- HTML
- Git
- CSS
- 클라우드컴퓨팅
- elastic net
- hackerrank
- 선형 모형
- coding
- merge
- RLIKE
- branch
- 온라인협업
- leetcode
- mysql
- 교차 엔트로피
- 버전충돌
- conflict
- 코딩공부
- 편향-분산 교환
- window function
- programmers
- PYTHON
- L1정규화
- early stopping
- sql
- Today
- Total
목록hackerrank (7)
Im between cherry
The Report Problem The Report | HackerRank Write a query to generate a report containing three columns: Name, Grade and Mark. www.hackerrank.com You are given two tables: Students and Grades. Students contains three columns ID, Name and Marks. Ketty gives Eve a task to generate a report containing three columns: Name, Grade and Mark. Ketty doesn't want the NAMES of those students who received a ..
Top Earners Problem Top Earners | HackerRank Find the maximum amount of money earned by any employee, as well as the number of top earners (people who have earned this amount). www.hackerrank.com We define an employee's total earnings to be their monthly salaryXmonths worked, and the maximum total earnings to be the maximum total earnings for any employee in the Employee table. Write a query to ..
Weather Observation Station 9 Problem Weather Observation Station 9 | HackerRank Query an alphabetically ordered list of CITY names not starting with vowels. www.hackerrank.com Query the list of CITY names from STATION that do not start with vowels. Your result cannot contain duplicates. Solution SELECT DISTINCT CITY FROM STATION WHERE SUBSTR(CITY, 1, 1) NOT IN ('a','e','i','o','u'); SELECT DIST..
Japanese Cities' Attributes Problem Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japan is JPN. The CITY table is described as follows: Japanese Cities' Attributes | HackerRank Query the attributes of all the cities in Japan. www.hackerrank.com Solution SELECT * FROM CITY WHERE countrycode = 'JPN'
Select By ID Problem Select By ID | HackerRank Query the details of the city with ID 1661. www.hackerrank.com - Solution SELECT * FROM City WHERE Id=1661
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 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'