[SQL문제풀기] Basic Select 2~7

문제1 - Revising the Select Query II

Revising the Select Query II | HackerRank

Query the city names for all American cities with populations larger than 120,000.

https://www.hackerrank.com/challenges/revising-the-select-query-2/problem?isFullScreen=true

MySQL, Oracle, DB2, MS SQL Server

내가 작성한 정답

select name
from city
where countrycode = 'USA'
    and population > 120000;

문제2 - Select All

Select All | HackerRank

Query all columns for every row in a table.

https://www.hackerrank.com/challenges/select-all-sql/problem?isFullScreen=true

MySQL, Oracle, DB2, MS SQL Server

내가 작성한 정답

select * from city;

문제3 - Select All

Select All | HackerRank

Query all columns for every row in a table.

https://www.hackerrank.com/challenges/select-all-sql/problem?isFullScreen=true

MySQL, Oracle, DB2, MS SQL Server

내가 작성한 정답

select * from city where id = 1661;

문제4 - Japanese Cities' Attributes

Japanese Cities' Attributes | HackerRank

Query the attributes of all the cities in Japan.

https://www.hackerrank.com/challenges/japanese-cities-attributes/problem?isFullScreen=true

MySQL, Oracle, DB2, MS SQL Server

내가 작성한 정답

select * from city where countrycode = 'JPN';

문제5 - Japanese Cities' Names

Japanese Cities' Names | HackerRank

In this challenge, you will query a list of all the Japanese cities' names.

https://www.hackerrank.com/challenges/japanese-cities-name/problem?isFullScreen=true

MySQL, Oracle, DB2, MS SQL Server

내가 작성한 정답

select name from city where countrycode = 'JPN';

문제6 - Japanese Cities' Names

MySQL, Oracle, DB2, MS SQL Server

내가 작성한 정답

select name from city where countrycode = 'JPN';