🔎 문제 https://www.hackerrank.com/challenges/salary-of-employees/problem?isFullScreen=true Write a query that prints a list of employee names (i.e.: the name attribute) for employees in Employee having a salary greater than 2000$ per month who have been employees for less than 10 months. Sort your result by ascending employee_id. - Employee 테이블에서 이름을 추출하라 - 월 별 salary가 2000$보다 크고 - 일한 month가 10개월보..

문제 https://www.hackerrank.com/challenges/name-of-employees/problem?isFullScreen=true Write a query that prints a list of employee names (i.e.: the name attribute) from the Employee table in alphabetical order. ○ Employee 테이블에서 알파벳 순으로 이름을 추출하라 풀이 SELECT NAME FROM EMPLOYEE ORDER BY NAME ASC;

문제 https://www.hackerrank.com/challenges/more-than-75-marks/problem?isFullScreen=true Query the Name of any student in STUDENTS who scored higher than Marks. Order your output by the last three characters of each name. If two or more students both have names ending in the same last three characters (i.e.: Bobby, Robby, etc.), secondary sort them by ascending ID. ○ STUDENTS 테이블에서 NAME을 추출하라 ○ MAR..

문제 https://www.hackerrank.com/challenges/weather-observation-station-12/problem?isFullScreen=true Query the list of CITY names from STATION that do not start with vowels and do not end with vowels. Your result cannot contain duplicates. ○ STATION 테이블에서 CITY의 이름이 모음으로 시작하지 않고(AND) 끝나지 않는 것을 추출하라 ○ 중복 X 풀이 SELECT DISTINCT(CITY) FROM STATION WHERE CITY REGEXP '^[^AEIOU].*[^AEIOU]$';

문제 https://www.hackerrank.com/challenges/weather-observation-station-11/problem?isFullScreen=true 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. ○ STATION 테이블에서 CITY의 이름이 모음으로 시작하지 않거나(OR) 끝나지 않는 것을 추출하라 ○ 중복 X 풀이 SELECT DISTINCT(CITY) FROM STATION WHERE CITY REGEXP '^[^A|E|I|O|U]' OR CITY REGEXP '[..

문제 https://www.hackerrank.com/challenges/weather-observation-station-10/problem?isFullScreen=true Query the list of CITY names from STATION that do not end with vowels. Your result cannot contain duplicates. ○ STATION 테이블에서 CITY의 이름이 모음으로 끝나지 않는 것을 추출해라 ○ 중복 X 풀이 SELECT DISTINCT(CITY) FROM STATION WHERE CITY REGEXP '[^A|E|I|O|U]$';

문제 https://www.hackerrank.com/challenges/weather-observation-station-9/problem?isFullScreen=true Query the list of CITY names from STATION that do not start with vowels. Your result cannot contain duplicates. ○ STATION 테이블에서 CITY의 이름이 모음으로 시작하지 않는 것을 추출해라 ○ 중복 X 풀이 SELECT DISTINCT(CITY) FROM STATION WHERE CITY REGEXP '^[^A|E|I|O|U]';

문제 https://www.hackerrank.com/challenges/weather-observation-station-8/problem?isFullScreen=true Query the list of CITY names from STATION which have vowels (i.e., a, e, i, o, and u) as both their first and last characters. Your result cannot contain duplicates. ○ STATION 테이블에서 CITY의 이름이 모음으로 시작해서 모음으로 끝나는 것을 추출해라 ○ 중복 X 풀이 SELECT DISTINCT(CITY) FROM STATION WHERE CITY REGEXP '^[A|E|I|O|U].*[A|E..