ALL (300) 썸네일형 리스트형 [해커랭크(HackerRank)] Weather Observation Station 6 (MySQL) 문제 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: where LAT_N is the northern latitude and LONG_W is the western longitude. 코드 SELECT DISTINCT city FROM Station WHERE city LIKE 'a%' OR city LIKE 'e%' OR city LIKE 'i%' OR city LIKE 'o%' OR city LIKE 'u%' 풀이 STAT.. [해커랭크(HackerRank)] Select By ID (MySQL) 문제 Query all columns for a city in CITY with the ID 1661. The CITY table is described as follows: 코드 SELECT * FROM CITY WHERE ID = 1661 풀이 CITY 테이블 전체 조회 ID의 타입은 NUMBER이나 ID = '1661' 로 입력했을 경우에도 문자형이지만 자동으로 변환이 되어 같은 결과가 출력됨 Select By ID | HackerRank Query the details of the city with ID 1661. www.hackerrank.com [해커랭크(HackerRank)] Revising the Select Query I(MySQL) 문제 Query all columns for all American cities in the CITY table with populations larger than 100000. The CountryCode for America is USA. The CITY table is described as follows: 코드 SELECT * FROM CITY WHERE population > 100000 AND countrycode = 'USA' 풀이 CITY 테이블의 모든 컬럼 조회 population이 100000명보다 커야함 [해커랭크(HackerRank)] Weather Observation Station 1 (MySQL) 문제 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 테이블에서 city, state 조회 Weather Observation Station 1 | HackerRank Write a query to print the CITY and STATE for each attribute in the STATION table. www.hackerrank.com 이전 1 ··· 43 44 45 46 47 48 49 ··· 75 다음
