관재탑

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 문제 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..

SQL/MySQL 문제풀이 2022. 7. 18. 16:34

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 문제 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. 정답쿼리 SELEC..

SQL/MySQL 문제풀이 2022. 7. 18. 15:37

https://www.hackerrank.com/challenges/weather-observation-station-6/problem?isFullScreen=true Weather Observation Station 6 | HackerRank Query a list of CITY names beginning with vowels (a, e, i, o, u). www.hackerrank.com 문제 Query the list of CITY names starting with vowels (i.e., a, e, i, o, or u) from STATION. Your result cannot contain duplicates. 정답 쿼리 SELECT DISTINCT CITY FROM STATION WHERE..

SQL/MySQL 문제풀이 2022. 7. 18. 15:24