[MySQL] Hacker Rank 문제 연습 2

Japanese Cities' Attributes (Basic Select)

• 문제
  

제출한 쿼리 :

SELECT *
FROM CITY
WHERE COUNTRYCODE = 'JPN';

---

Weather Observation Station 1 (Basic Select)

• 문제
  

제출한 쿼리 :

SELECT CITY
       , STATE
FROM STATION

---

Weather Observation Station 2 (Aggregation)

• 문제
  

제출한 쿼리 :

SELECT ROUND(SUM(LAT_N), 2) AS LAT
       , ROUND(SUM(LONG_W), 2) AS LON
FROM STATION;

---

Weather Observation Station 3 (Basic Select)

• 문제
  

제출한 쿼리 :

SELECT DISTINCT CITY
FROM STATION
WHERE ID % 2 = 0;

---

Weather Observation Station 4 (Basic Select)

• 

제출한 쿼리 :

SELECT COUNT(*) - COUNT(DISTINCT CITY)
FROM STATION;

---