문제 https://www.hackerrank.com/challenges/what-type-of-triangle/problem?isFullScreen=true Type of Triangle | HackerRank Query a triangle's type based on its side lengths. www.hackerrank.com Equilateral: It's a triangle with sides of equal length. 정삼각형 : 변의 길이가 같은 삼각형입니다. Isosceles: It's a triangle with sides of equal length. 이등변삼각형: 변의 길이가 같은 삼각형입니다. Scalene: It's a triangle with sides of differi..

문제 https://www.hackerrank.com/challenges/salary-of-employees/problem?isFullScreen=true 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 풀이(MSSQL) SELECT NAME FROM EMPLOYEE WHERE SALARY > 2000 AND MONTHS < 10 ORDER BY EMPLOYEE_ID 조건 1. 샐러리가 2000 초과 조건 2. 일한 달 10달 미만 조건 3. 조회 순서..

문제 https://www.hackerrank.com/challenges/name-of-employees/problem?isFullScreen=true Employee Names | HackerRank Print employee names. www.hackerrank.com 풀이(MSSQL) SELECT NAME FROM EMPLOYEE ORDER BY NAME

문제 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 풀이(MSSQL) SELECT NAME FROM STUDENTS WHERE MARKS > 75 ORDER BY RIGHT(NAME, 3), ID; 조건 1. 학생의 점수는 75점 이상 조건 2. 학생 조회 순서는 이름의 오른쪽 3개로 정렬 조건 3. 그 ..

문제 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 풀이(MSSQL) SELECT DISTINCT CITY FROM STATION WHERE NOT CITY LIKE '[aeuio]%' AND NOT CITY LIKE '%[aeuio]'

문제 https://www.hackerrank.com/challenges/weather-observation-station-11/problem?isFullScreen=true Weather Observation Station 11 | HackerRank Query a list of CITY names not starting or ending with vowels. www.hackerrank.com 풀이(MSSQL) SELECT DISTINCT CITY FROM STATION WHERE NOT CITY LIKE '[aeuio]%' OR NOT CITY LIKE '%[aeuio]'

문제 https://www.hackerrank.com/challenges/weather-observation-station-10/problem?isFullScreen=true Weather Observation Station 10 | HackerRank Query a list of CITY names not ending in vowels. www.hackerrank.com 풀이(MSSQL) SELECT DISTINCT CITY FROM STATION WHERE NOT CITY LIKE '%[aueio]' 문제는 모음으로 끝나지 않는 도시에서 중복되지 않게 도시이름을 조회하는 거라 그 전에 풀었던 거에서 % 위치만 변경하면 쉽게 풀 수 있었다.

문제 https://www.hackerrank.com/challenges/weather-observation-station-9/problem?isFullScreen=true Weather Observation Station 9 | HackerRank Query an alphabetically ordered list of CITY names not starting with vowels. www.hackerrank.com 풀이(MSSQL) SELECT DISTINCT CITY FROM STATION WHERE NOT CITY LIKE '[aieuo]%' 모음으로 시작하지 않는 조건으로 인해 WHERE 조건 뒤에 NOT 만 붙히면 된다.

문제 https://www.hackerrank.com/challenges/weather-observation-station-8/problem?isFullScreen=true Weather Observation Station 8 | HackerRank Query CITY names that start AND end with vowels. www.hackerrank.com 풀이(MSSQL) SELECT DISTINCT CITY FROM STATION WHERE CITY LIKE '[aeiou]%' AND CITY LIKE '%[aeiou]'; 전 문제는 조건이 간단하여 그냥 일일히 작성하였지만 이번엔 조건으로 하나씩 만들기에는 25개를 만들어야하기 때문에 이번엔 정규표현식으로 해결을 해보았다.