SQL/HackerRank (10) 썸네일형 리스트형 [SQL] HackeRank : Weather Observation Station 11 문제 Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates. 실행코드 # either do not start with vowels or do not end with vowels -> 모음으로 시작하지 않거나 모음으로 끝나지 않는 도시 추출 -> 모음으로 시작해서 모음으로 끝나는 도시는 X city NOT LIKE 'a%' : city 컬럼에서 'a'로 시작하지 않는~ (%는 와일드카드 : 뒤에 몇 글자가 오든 상관X) +다른 풀이 방법(feat. SQL스터디) #1 SUBSTRING 함수 이용 SUBST.. [SQL] HackerRank : The Blunder 문제 Samantha was tasked with calculating the average monthly salaries for all employees in the EMPLOYEES table, but did not realize her keyboard's key was broken until after completing the calculation. She wants your help finding the difference between her miscalculation (using salaries with any zeros removed), and the actual average salary. Write a query calculating the amount of error (i.e.: av.. 이전 1 2 다음
