mun dev

문제링크 Type of Triangle | HackerRank Query a triangle's type based on its side lengths. www.hackerrank.com 풀이 문제 조건에 맞게 3개의 변이 같은 경우, 2개의 변이 같은 경우, 3개의 변이 다 다르고 가장 큰 변보다 두 변의 길이가 더 작거나 같은 경우를 고려해서 case when then을 사용해서 풀이했다. 코드 SELECT CASE WHEN A = B AND B = C THEN 'Equilateral' WHEN A+B

문제링크 Employee Salaries | HackerRank Print the names of employees who earn more than $2000 per month and have worked at the company for less than 10 months. www.hackerrank.com 코드 select name from employee where months = 2000 order by employee_id asc;

문제링크 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 풀이 75점보다 큰 점수와 마지막 세글자를 기준으로 정렬하고, 세글자가 같다면 아이디를 기준으로 정렬해야 한다. 1. where문에는 점수에 대한 조건을 작성 2. 정렬하는 order by절에 이름을 substr()함수를 사용해 잘라서 정렬 3. 이후 아이디를 기준으로 정렬한다. 코드 select name from students where marks > 75 order by substr(name..

문제링크 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 (upper(city) not like 'A%' and upper(city) not like 'E%' and upper(city) not like 'I%' and upper(city) not like 'O%' and upper(city) not like 'U%') and (upper(city) not like '%A' and upper(city) not ..

문제링크 Weather Observation Station 11 | HackerRank Query a list of CITY names not starting or ending with vowels. www.hackerrank.com 코드 select distinct city from station where (upper(city) not like 'A%' and upper(city) not like 'E%' and upper(city) not like 'I%' and upper(city) not like 'O%' and upper(city) not like 'U%') or (upper(city) not like '%A' and upper(city) not like '%E' and upper(city) ..

문제링크 Weather Observation Station 9 | HackerRank Query an alphabetically ordered list of CITY names not starting with vowels. www.hackerrank.com 코드 select distinct city from station where (upper(city) not like 'A%' and upper(city) not like 'E%' and upper(city) not like 'I%' and upper(city) not like 'O%' and upper(city) not like 'U%');

문제링크 Weather Observation Station 8 | HackerRank Query CITY names that start AND end with vowels. www.hackerrank.com 풀이 도시 이름이 모음으로 시작하지 않고, 모음으로 끝나지 않는 문제의 조건에 따라 like함수를 사용해 풀이하면 된다. 코드 select distinct city from station where (upper(city) like 'A%' or upper(city) like 'E%' or upper(city) like 'I%' or upper(city) like 'O%' or upper(city) like 'U%') and (upper(city) like '%A' or upper(city) like ..

문제링크 Weather Observation Station 7 | HackerRank Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. www.hackerrank.com 풀이 도시 이름이 모음으로 끝나는 문제의 조건에 따라 like 함수를 사용해서 풀이하면 된다. 코드 select distinct city from station where (upper(city) like '%A' or upper(city) like '%E' or upper(city) like '%I' or upper(city) like '%O' or upper(city) like '%U');