Analysis/SQL5 [MySQL] HackerRank - Weather Observation Station 18-20 Table 'STATION' Field Type Note ID NUMBER CITY VARCHAR2 (21) Cities in USA STATE VARCHAR2 (2) States in USA LAT_N NUMBER Northern Latitude LONG_W NUMBER Western Longitude - Weather Observation Station 18, 19, 20 - SubDomain: Aggregation - Skills: SQL Basic, SQL Intermediate Question 18 Answer SELECT ROUND(ABS(MIN(lat_n)-MAX(lat_n)) + ABS(MIN(long_w)-MAX(long_w)),4) FROM station; Question 19 Answ.. 2023. 8. 12. [MySQL] HackerRank - Weather Observation Station 13-17 Table 'STATION' Field Type Note ID NUMBER CITY VARCHAR2 (21) Cities in USA STATE VARCHAR2 (2) States in USA LAT_N NUMBER Northern Latitude LONG_W NUMBER Western Longitude - Weather Observation Station 13, 14, 15, 16, 17 - SubDomain: Aggregation - Skills: SQL Basic Question 13 Query the sum of Northern Latitudes (LAT_N) from STATION having values greater than 38.7880 and less than 137.2345. Trunc.. 2023. 8. 11. 이전 1 2 다음
