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.
  1. Practice
  2. SQL
  3. Basic Select
  4. Weather Observation Station 1
  5. Discussions

Weather Observation Station 1

Sort 107 Discussions, By:

votes

  • miftahul151136 + 3 comments

    where LAT_N is the northern latitude and LONG_W is the western longitude

    why this sentence didnot make any matter for this query?

    • kev_rocky + 0 comments

      I think it's supposed to be a red herring.

    • nicwalsh101 + 0 comments

      It's trying to trick you. Just focus on what the question actually wants you to do.

    • balvpro + 1 comment

      I thought we should add filter condition like where LAT_N > 0 and LONG_W < 0. Either the problem or test case in anwser should be updated to avoid confuse.

      • lusecosa + 0 comments

        I tried the same. This exercise is very confused.

  • jajudeepali + 1 comment

    You will get the correct answer by removing*/ symbols and write just a query Select City, State From Station;

    • eng_shalu + 2 comments

      its not working

      • neerajswami26 + 0 comments

        SELECT CITY, STATE from STATION;

        dont forget at put semicolon ; at end of line in your query

      • salivinit28 + 2 comments

        PUT COMMA(,) IN TNE MIDDLE OF CITY AND STATE

        • haddenbrandon + 0 comments

          ^^ This. No space between City,State. Just the comma

        • traybanks96 + 0 comments

          is there a particular reason why we use , over the AND operator in this situation? I have used it before with no problem but when I did it this time it only returned 0 for all my query data. can you tell me what exactly happened here that would be greatly appreciated.?

  • coder_aky + 3 comments

    100% Working Simple and easy :-)

    SELECT CITY,STATE FROM STATION;
    • rathoreniks53 + 1 comment

      not working i also think it first here bt the compiler dont take it.

      • liang_li_ness + 1 comment

        me too :(

        • coder_aky + 0 comments

          It working , see if you are using MySQL language tab .

    • sugandha_ammini + 0 comments

      can't i use "and" here in place of ","

    • haritha_excelle1 + 1 comment

      why we should not use and operator instead of coma?

      • pnayak0916 + 0 comments

        Because in the SELECT clause we query the column name and these are always written separated by commas (, ). Even if there are only two column names to be written we separate them by comma.

        Also, AND is a operator used in WHERE clause.

  • Jitender98 + 0 comments

    MySQL code-

    SELECT city, state
FROM station;

  • hp6067 + 2 comments

    Don't know why the */ symbols are there suddenly? Confusing for those of us very new to SQL as if you put your code where it suggests the request doesn't work. Assume it's a comment syntax?

    • kev_rocky + 0 comments

      The * means 'select all'.

      So if you're saying, and I'm going to write this in psuedocode -

      Select (all the fields --> or * ) from (the the station table).

    • A5537 + 0 comments

      Yes, /* ... */ is a multi-line comment. See w3schools SQL Comments tutorial for more details.

Load more conversations