We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
Loading...
  • Practice
  • Compete
  • Jobs
  • Leaderboard
  • Hiring developers?
  1. Practice
  2. SQL
  3. Basic Select
  4. Weather Observation Station 5
  5. Discussions

Weather Observation Station 5

  • Problem
  • Submissions
  • Leaderboard
  • Discussions

    You are viewing a single comment's thread. Return to all comments →

  • hous61 6 months ago+ 1 comment

    can you please tell me why do you add the limit 1 part?

    0|
    ParentPermalink
    • JessePattinson 4 months ago+ 0 comments

      The queries we write for this challenge are meant to return the city with the longest name and the city with the shortest name (with city name sort order as a tie breaker). The "limit 1" here is so that each query only returns the first result, thus returning the longest and shortest city names.

      0|
      ParentPermalink
  • Contest Calendar
  • Blog
  • Scoring
  • Environment
  • FAQ
  • About Us
  • Support
  • Careers
  • Terms Of Service
  • Privacy Policy
  • Request a Feature