문제링크 : https://www.hackerrank.com/challenges/japanese-cities-name/problem?isFullScreen=true ❓문제 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: ❗답 SELECT NAME FROM CITY WHERE COUNTRYCODE = 'JPN'; 🤔풀이 where절에 조건

문제링크 : https://www.hackerrank.com/challenges/select-all-sql/problem?isFullScreen=true ❓문제 Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japan is JPN. The CITY table is described as follows: ❗답 SELECT * FROM CITY WHERE COUNTRYCODE ='JPN'; 🤔풀이 wher절에 조건

문제링크 : https://www.hackerrank.com/challenges/select-by-id/problem?isFullScreen=true ❓문제 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; 🤔풀이 Number Type은 ''가 없어도 된다.

문제링크 : https://www.hackerrank.com/challenges/select-all-sql/problem?isFullScreen=true ❓문제 Query all columns (attributes) for every row in the CITY table. The CITY table is described as follows: ❗답 SELECT * FROM CITY; 🤔풀이

문제링크 : https://www.hackerrank.com/challenges/revising-the-select-query-2/problem?isFullScreen=true ❓문제 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 NAME FROM CITY WHERE POPULATION >120000 AND COUNTRYCODE = 'USA'; 🤔풀이 Revising the Select Query 1과 비슷한 문제다. NA..

문제링크 : https://www.hackerrank.com/challenges/revising-the-select-query/problem?isFullScreen=true ❓문제 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'; 🤔풀이 간단한 SQL문제이다. CITY table에서 population이 100000 이상..