공부
-
[HackerRank/Basic Select] Weather Observation Station 1공부/PS ( SQL) 2021. 9. 24. 01:23
https://www.hackerrank.com/challenges/weather-observation-station-1/problem Weather Observation Station 1 | HackerRank Write a query to print the CITY and STATE for each attribute in the STATION table. www.hackerrank.com SELECT CITY, STATE FROM STATION
-
[HackerRank/Basic Select] Japanese Cities' Names공부/PS ( SQL) 2021. 9. 24. 01:19
https://www.hackerrank.com/challenges/japanese-cities-name/problem Japanese Cities' Names | HackerRank In this challenge, you will query a list of all the Japanese cities' names. www.hackerrank.com SELECT NAME FROM CITY WHERE COUNTRYCODE LIKE 'JPN'
-
[HackerRank/Basic Select] Japanese Cities' Attributes공부/PS ( SQL) 2021. 9. 24. 01:18
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 SELECT * FROM CITY WHERE COUNTRYCODE LIKE 'JPN'
-
[HackerRank/Basic Select] Revising the Select Query II공부/PS ( SQL) 2021. 9. 24. 01:13
https://www.hackerrank.com/challenges/revising-the-select-query-2/problem Revising the Select Query II | HackerRank Query the city names for all American cities with populations larger than 120,000. www.hackerrank.com SELECT NAME FROM CITY WHERE POPULATION > 120000 AND COUNTRYCODE LIKE 'USA'
-
[HackerRank/Basic Select] Revising the Select Query I공부/PS ( SQL) 2021. 9. 24. 01:10
https://www.hackerrank.com/challenges/revising-the-select-query/problem Revising the Select Query I | HackerRank Query the data for all American cities with populations larger than 100,000. www.hackerrank.com SELECT * FROM CITY WHERE POPULATION > 100000 AND COUNTRYCODE LIKE 'USA'