Where5 [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 - Japanese Cities' Attributes Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japan is JPN. The CITY table is described as follows: 단순 WHERE 사용 STRING 일치 비교 문제 COUNTRYCODE가 JPN인 컬럼의 모든 정보 출력 코드 더보기 SELECT * FROM CITY WHERE COUNTRYCODE = 'JPN'; 2022. 5. 31. [MYSQL] HACKERRANK - SELECT BY ID https://www.hackerrank.com/challenges/select-by-id Select By ID | HackerRank Query the details of the city with ID 1661. www.hackerrank.com Query all columns for a city in CITY with the ID 1661. The CITY table is described as follows: WHERE문 사용 문제 ID가 1661인 것만 출력 코드 더보기 SELECT * FROM CITY WHERE ID = 1661; 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 2 다음
