SQL (21) 썸네일형 리스트형 [MySQL/HackerRank] Japanese Cities' Attributes Question Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japan is JPN. The CITY table is described as follows: My Answer SELECT * FROM CITY WHERE COUNTRYCODE = 'JPN'; Result 출처 : https://www.hackerrank.com/challenges/japanese-cities-attributes/problem Japanese Cities' Attributes | HackerRank Query the attributes of all the cities in Japan. www.hackerrank.com [MySQL/HackerRank] Select By ID Question Query all columns for a city in CITY with the ID 1661. The CITY table is described as follows: My Answer SELECT * FROM CITY WHERE ID = 1661; Result 출처 : https://www.hackerrank.com/challenges/select-by-id/problem Select By ID | HackerRank Query the details of the city with ID 1661. www.hackerrank.com [MySQL/HackerRank] Select All Question Query all columns (attributes) for every row in the CITY table. The CITY table is described as follows: My Answer SELECT * FROM CITY; Result 출처 : https://www.hackerrank.com/challenges/select-all-sql/problem Select All | HackerRank Query all columns for every row in a table. www.hackerrank.com [MySQL/HackerRank] Revising the Select Query II Question 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: My Answer SELECT NAME FROM CITY WHERE POPULATION > 120000 AND COUNTRYCODE = 'USA'; Result 출처 : https://www.hackerrank.com/challenges/revising-the-select-query-2/problem Revising the Select Query II | HackerRank Qu.. [MySQL/HackerRank] Revising the Select Query I Question 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: My Answer select * from city where population > 100000 and countrycode = 'USA'; Result 출처 : https://www.hackerrank.com/challenges/revising-the-select-query/problem Revising the Select Query I | HackerRank Query the d.. 이전 1 2 3 다음
