문제 https://www.hackerrank.com/challenges/select-all-sql/problem?isFullScreen=true Select All | HackerRank Query all columns for every row in a table. www.hackerrank.com 풀이(MSSQL) SELECT * FROM CITY

문제 https://www.hackerrank.com/challenges/revising-the-select-query-2/problem?isFullScreen=true Revising the Select Query II | HackerRank Query the city names for all American cities with populations larger than 120,000. www.hackerrank.com 풀이(MSSQL) SELECT NAME FROM CITY WHERE POPULATION > 120000 AND COUNTRYCODE LIKE 'USA'

문제 https://www.hackerrank.com/challenges/revising-the-select-query/problem?isFullScreen=true Revising the Select Query I | HackerRank Query the data for all American cities with populations larger than 100,000. www.hackerrank.com 풀이(MSSQL) SELECT * FROM CITY WHERE COUNTRYCODE LIKE 'USA' AND POPULATION > 100000 CountryCode가 USA 이면서 Population이 100000보다 큰 경우가 조건으로 SELECT를 해야한다.