공부/PS ( SQL)
-
[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'