MySQL17 [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 - 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 2 3 4 5 다음
