문제 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 Format The STATION table is described as follows: 문제 요약 CITY 앞글자가 모음인 경우를 추출하라 풀이 SELECT CITY FROM STATION WHERE CITY REGEXP "^[aeiou].*"; 배운점 REGEXP : LIKE 검색과 달리 정규식을 이용한 검색방식이다. WHERE NAME REGEXP '가' > '가'를 포함한 모든 레코드 WHERE NAME REGEXP '가|나|다|라' > '가' 또는 '나'..
문제 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 described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude. Sample Input ..
문제 Amber's conglomerate corporation just acquired some new companies. Each of the companies follows this hierarchy: Given the table schemas below, write a query to print the company_code, founder name, total number of lead managers, total number of senior managers, total number of managers, and total number of employees. Order your output by ascending company_code. Note: The tables may contain d..
