문제링크 : 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. (Marks가 75보다 높은 학생. 이름의 마..

문제링크 : https://www.hackerrank.com/challenges/weather-observation-station-12/problem?isFullScreen=true&h_r=next-challenge&h_v=zen ❓문제 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. (모음으로 시작과 끝 둘 다 하면 안됨. 중복 허용 X) Input Format The STATION table is described as follows: where LAT_N is the northern latitude a..

문제링크 : 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. (모음으로 시작도 끝도 하지않음. 중복 허용 X) Input Format The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western ..

문제링크 : 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. (모음으로 끝나지 않는 도시 이름, 중복 포함X) Input Format The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude. ❗답 SELECT DISTINCT CITY ..

문제링크 : https://www.hackerrank.com/challenges/weather-observation-station-6/problem?isFullScreen=true ❓문제 Query the list of CITY names starting with vowels (i.e., a, e, i, o, or u) from STATION. Your result cannot contain duplicates. Input FormatThe STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude. ❗답 SELECT DISTINCT CITY FROM STATION..

문제링크 : https://www.hackerrank.com/challenges/weather-observation-station-5/problem?isFullScreen=true ❓문제 Query the two cities in STATION with the shortest and longest CITY names, as well as their respective lengths (i.e.: number of characters in the name). If there is more than one smallest or largest city, choose the one that comes first when ordered alphabetically. The STATION table is describ..

문제링크 : https://www.hackerrank.com/challenges/weather-observation-station-3/problem?isFullScreen=true ❓문제 Query a list of CITY names from STATION for cities that have an even ID number. Print the results in any order, but exclude duplicates from the answer. The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the ❗답 SELECT DISTINCT CITY FROM STATION WHERE ..

문제링크 : https://www.hackerrank.com/challenges/weather-observation-station-1/problem?isFullScreen=true ❓문제 Query a list of CITY and STATE from the STATION table. The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude. ❗답 SELECT CITY, STATE FROM STATION; 🤔풀이 STATION table에서 CITY, STATE 출