블로그
- Japanese Cities' Attributes in the CITY table. The CITY table is described as follows: SELECT * FROM CITY WHERE COUNTRYCODE = 'JPN';
- Select All table. The CITY table is described as follows: SELECT * FROM CITY
- Japanese Cities' Names table. The CITY table is described as follows: SELECT NAME FROM CITY WHERE COUNTRYCODE = 'JPN';
- Weather Observation Station 4 entries in the table and the number of distinct CITY entries in the table. For example, if there are three records in the table with CITY values 'New York', 'New York', 'Bengalaru
- Revising the Select Query II table with populations larger than 120000. The CITY table is described as follows: SELECT NAME FROM CITY WHERE COUNTRYCODE = 'USA' AND POPULATION
- Select By ID Prepare > SQL > Basic Select > Select By ID Query all columns for a city in CITY with the ID The CITY table is described as follows: SELECT * FROM city WHERE ID = 1661;
- Weather Observation Station 1 from the STATION table. SELECT CITY, STATE FROM STATION
- Revising the Select Query I table with populations larger than 100000. The CITY table is described as follows: https://www.hackerrank.com/challenges/revising-the-select-query
- Weather Observation Station 3 Prepare > SQL > Basic Select > Weather Observation Station 3 Query a list of CITY names from SELECT DISTINCT CITY FROM STATION WHERE MOD(ID, 2) = 0; 짝수(even ID) = MOD(column, 2) = 0
- Weather Observation Station 5 Select > Weather Observation Station 5 Query the two cities in STATION with the shortest and longest CITY Sample Input For example, CITY has four entries: DEF, ABC, PQRS and WXY.