Weather Observation Station 5

Sort by

recency

|

7211 Discussions

|

  • + 0 comments

    (SELECT CITY, LENGTH(CITY) FROM STATION WHERE LENGTH(CITY) = (SELECT MIN(LENGTH(CITY)) FROM STATION) ORDER BY CITY ASC LIMIT 1) UNION (SELECT CITY, LENGTH(CITY) FROM STATION WHERE LENGTH(CITY) = (SELECT MAX(LENGTH(CITY)) FROM STATION) ORDER BY CITY ASC LIMIT 1);

  • + 0 comments

    I set Limit = 1, because in problem they just ask the fist row only.

    **SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY) ASC, CITY ASC LIMIT 1; SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY) DESC, CITY DESC LIMIT 1; **

  • + 1 comment

    We can Either use 2 different Queries or union both queries as everyone did.

  • + 0 comments

    according to these question we are write query but return a wrong answer SELECT CITY , LENGTH(CITY) AS NAME_LENGTH FROM STATION ORDER BY LENGTH(CITY) ASC, CITY ASC LIMIT 1 ) UNION ( SELECT CITY , LENGTH(CITY) AS NAME_LENGTH FROM STATION ORDER BY LENGTH(CITY) DESC, CITY ASC LIMIT 1 );

  • + 0 comments

    SELECT s.CITY, LENGTH(s.CITY) FROM ( SELECT CITY FROM STATION ORDER BY LENGTH(CITY), CITY FETCH FIRST 1 ROW ONLY) s UNION ALL SELECT l.CITY, LENGTH(l.CITY) FROM ( SELECT CITY FROM STATION ORDER BY LENGTH(CITY) DESC, CITY FETCH FIRST 1 ROW ONLY) l;