Weather Observation Station 5

  • + 0 comments

    [Second Query]Select City,char_LENGTH(City) from Station Order By Length(City) desc, City desc limit 1;

    Here city should be asc as we need to sort city in ascending order of their occurance. so final query Select City,char_LENGTH(City) from Station Order By Length(City) desc, City asc limit 1;