융무의 기술블로그
article thumbnail
[SQL][HackerRank] Select By ID
Algorithm/SQL 2020. 6. 8. 22:34

https://www.hackerrank.com/challenges/select-by-id/problem?h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen Select By ID | HackerRank Query the details of the city with ID 1661. www.hackerrank.com SELECT * FROM CITY WHERE ID = 1661;

article thumbnail
[SQL][HackerRank] Select All
Algorithm/SQL 2020. 6. 8. 22:29

https://www.hackerrank.com/challenges/select-all-sql/problem?h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen Select All | HackerRank Query all columns for every row in a table. www.hackerrank.com SELECT * FROM CITY

article thumbnail
[SQL][HackerRank] Revising the Select Query II
Algorithm/SQL 2020. 6. 8. 22:25

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 = 'USA'

article thumbnail
[SQL][HackerRank] Revising the Select Query I
Algorithm/SQL 2020. 6. 8. 22:23

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 = 'USA'