응엉이의 엉엉코딩일기

https://www.hackerrank.com/challenges/earnings-of-employees/problem?h_r=internal-search 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 가장 높은 연봉과 가장 높은 연봉을 받는 사람 수를 출력하는 문제 SELECT MAX(salary * months), COUNT(*) FROM employee WHERE salary * months = (SELECT MAX(salary * ..

https://www.hackerrank.com/challenges/weather-observation-station-15/problem?isFullScreen=true 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 소숫점 처리 CEIL(숫자) -- 올림 FLOOR(숫자) -- 내림 ROUND(숫자, 자리수) -- 반올림 최대/최솟값 찾기 -> ORDER BY + LIMIT 조합 SELECT ROUND(long_w, 4) FROM station WHE..

https://www.hackerrank.com/challenges/more-than-75-marks/problem?isFullScreen=true 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 SELECT name FROM students WHERE marks > 75 ORDER BY RIGHT(name, 3), id SQL 내 문자열 자르기 함수 LEFT(col_name or str, 길이) RIGHT(col_name or str, 길이) SUBS..

https://www.hackerrank.com/challenges/weather-observation-station-12/problem?isFullScreen=true Weather Observation Station 12 | HackerRank Query an alphabetically ordered list of CITY names not starting and ending with vowels. www.hackerrank.com SELECT DISTINCT city FROM station WHERE city NOT LIKE 'a%' AND city NOT LIKE 'e%' AND city NOT LIKE 'i%' AND city NOT LIKE 'o%' AND city NOT LIKE 'u%' A..

Weather Observation Station 6 | HackerRank Query a list of CITY names beginning with vowels (a, e, i, o, u). www.hackerrank.com SELECT DISTINCT city FROM station WHERE city LIKE 'a%' OR city LIKE 'e%' OR city LIKE 'i%' OR city LIKE 'o%' OR city LIKE 'u%' WHERE : 조건문 LIKE : 데이터에서 패턴 찾기 OR : 여러개의 조건 연결