select4 [MYSQL] HACKERRANK - Weather Observation Station 1 https://www.hackerrank.com/challenges/weather-observation-station-1/problem Weather Observation Station 1 | HackerRank Write a query to print the CITY and STATE for each attribute in the STATION table. www.hackerrank.com 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. 생각해보기.. 2022. 6. 1. [MYSQL] HACKERRANK - Japanese Cities' Names Query the names of all the Japanese cities in the CITY table. The COUNTRYCODE for Japan is JPN. The CITY table is described as follows: 이전 문제 : https://hdobby.tistory.com/7 이전 문제에서 SELECT에 특정 컬럼만 추가해주는 문제 COUNTRYCODE는 JPN NAME만 출력 코드 더보기 SELECT NAME FROM CITY WHERE COUNTRYCODE = 'JPN'; 2022. 5. 31. [MYSQL] HACKERRANK - SELECT ALL https://www.hackerrank.com/challenges/select-all-sql Select All | HackerRank Query all columns for every row in a table. www.hackerrank.com Query all columns (attributes) for every row in the CITY table. The CITY table is described as follows: 단순 SELECT문 사용 문제 제한 없이 전부 출력! 코드 더보기 SELECT * FROM CITY; 2022. 5. 31. [MYSQL] HACKERRANK - Revising the Select Query II https://www.hackerrank.com/challenges/revising-the-select-query-2 Revising the Select Query I | HackerRank Query the data for all American cities with populations larger than 100,000. www.hackerrank.com Query the NAME field for all American cities in the CITY table with populations larger than 120000. The CountryCode for America is USA. The CITY table is described as follows: 이전 문제와의 차이점은 Select.. 2022. 5. 31. 이전 1 다음
