Weather Observation Station 18 -- a=MIN(LAT_N) -- B=MIN(LONG_W) -- C=MAX(LAT_N) -- D=MAX(LONG_W) -- round(distance, 4) -- DISTANCE = |A-C| + |B-D| SELECT ROUND((ABS(MIN(LAT_N)-MAX(LAT_N)) + (ABS(MIN(LONG_W)-MAX(LONG_W)))),4) FROM STATION; Weather Observation Station 19 -- A= MIN(LAT_N) -- B=MAX(LAT_N) -- C=MIN(LONG_W) -- D= MAX(LONG_W) -- Distance(p1,p2)^2 = (A-C)^2 - (B-D)^2 -- sqrt(pow()) SELE..

The Blunder 기존 월평균 급여 - 0 제거한 월 평균 점수 올림 -> ceil (올림 함수) select ceil(avg(salary)-avg(replace(salary,0,''))) from employees; Top Earners SELECT (salary*months) AS earnings, COUNT(*) FROM EMPLOYEE GROUP BY earnings ORDER BY earnings DESC LIMIT 1; Weather Observation Station 2 SELECT ROUND(SUM(LAT_N),2), ROUND(SUM(LONG_W),2) FROM STATION; Weather Observation Station 13 SELECT ROUND(SUM(LAT_N),4) FR..

BASIC Revising the Select Query 1 Select * from CITY where POPULATION >100000 AND COUNTRYCODE = "USA"; select All Select * From CITY select by id Select * FROM CITY WHERE ID=1661; Japanese Cities' attributes Select * FROM CITY WHERE COUNTRYCODE = 'JPN'; Japanese Cities' Name SELECT NAME FROM CITY WHERE COUNTRYCODE='JPN'; Weather Observation Station 1 SELECT CITY, STATE FROM STATION; Weather Obse..