1. The PADS https://www.hackerrank.com/challenges/the-pads/problem?isFullScreen=true The PADS | HackerRank Query the name and abbreviated occupation for each person in OCCUPATIONS. www.hackerrank.com lv. medium 문제 Generate the following two result sets: 1. Query an alphabetically ordered list of all names in OCCUPATIONS, immediately followed by the first letter of each profession as a parentheti..
1. Weather Observation Station 7 https://www.hackerrank.com/challenges/weather-observation-station-7/problem?isFullScreen=true Weather Observation Station 7 | HackerRank Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. www.hackerrank.com lv. easy 문제 Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. Your result cannot contain duplicates. CO..
SQL 스터디가 프로그래머스 문제를 마무리하고 해커랭크 문제풀이를 시작했다. 근데 난 밀려서 이제 인증한다. 조금 밀렸더니 써야하는 블로그가 순식간에 불어났다. 역시 사람은 조금도 나태해지면 안된다는 걸 다시금 깨달으며.... 1. Revising the Select Query I https://www.hackerrank.com/challenges/revising-the-select-query/problem?isFullScreen=true Revising the Select Query I | HackerRank Query the data for all American cities with populations larger than 100,000. www.hackerrank.com lv. easy 문제 Q..
