• Skip to primary navigation
  • Skip to content
  • Skip to footer
슬기로운데이터생활
  • Posts
  • Categories
  • Tags
  • About
    JINYOUNG SUL

    JINYOUNG SUL

    데이터 속에 답이 있다.

    • GitHub
    • Instagram

    HackerRank-Aggregation-Weather Observation Station 14

    less than 1 minute read

    Weather Observation Station 14

    Query the greatest value of the Northern Latitudes (LAT_N) from STATION that is less than 137.2345. Truncate your answer to 4 decimal places.

    Input Format

    The STATION table is described as follows:

    **My solution **

    SELECT ROUND(MAX(LAT_N),4)
    FROM STATION
    WHERE LAT_N < 137.2345;
    

    Tags: sql

    Categories: sql

    Updated: July 9, 2021

    Twitter Facebook LinkedIn
    Previous Next

    Comments

    You May Also Enjoy

    HackerRank-SQL Project Planning

    1 minute read

    SQL Project Planning

    HackerRank-AdvancedJoin-Interviews

    2 minute read

    Interviews

    HackerRank-AdvancedJoin-Symmetric Pairs

    less than 1 minute read

    Symmetric Pairs

    HackerRank-AdvancedJoin-Placements

    1 minute read

    Placements

    • GitHub
    • Instagram
    • Feed
    © 2021 슬기로운데이터생활 . Powered by Jekyll & Minimal Mistakes.