MySQL17 [MYSQL] HACKERRANK - Weather Observation Station 4 https://www.hackerrank.com/challenges/weather-observation-station-4 Weather Observation Station 4 | HackerRank Find the number of duplicate CITY names in STATION. www.hackerrank.com 문제 Find the difference between the total number of CITY entries in the table and the number of distinct CITY entries in the table. The STATION table is described as follows: where LAT_N is the northern latitude and L.. 2022. 6. 3. [MYSQL] HACKERRANK - Weather Observation Station 3 https://www.hackerrank.com/challenges/weather-observation-station-3/problem Weather Observation Station 3 | HackerRank Query a list of unique CITY names with even ID numbers. www.hackerrank.com 문제 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 .. 2022. 6. 3. [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. 이전 1 2 3 4 5 다음
