[MySQL] HackerRank 문제 연습 1

Select ALL (Basic Select)

• 문제
  

제출한 쿼리 :

SELECT *
FROM CITY

---

Select By ID (Basic Select)

• 문제
  

제출한 쿼리 :

SELECT * 
FROM CITY
WHERE ID = 1661;

---

Revising the Select Query(I) (Basic Select)

• 문제
  

제출한 쿼리 :

SELECT *
FROM CITY
WHERE population > 100000
    AND CountryCode = 'USA';

---

Revising the Select Query(II) (Basic Select)

• 문제
  

제출한 쿼리 :

SELECT NAME
FROM CITY
WHERE POPULATION > 120000 
    AND COUNTRYCODE = "USA";

---

Japanese Cities' Names (Basic Select)

• 문제
  

제출한 쿼리 :

SELECT name
FROM CITY
WHERE COUNTRYCODE = 'JPN';

---