Query the two cities in STATION with the shortest and longest CITY names, as well as their respective lengths (i. e.: number of characters in the name). If there is more than one smallest or largest city, choose the one that comes first when ordered alphabetically.

If there is more than one smallest or largest city, choose the one that comes first when ordered alphabetically.

Explanation has given below.

Explanation:

Lets us consider and focused on the problem

Suppose that the City has Latitude_N for northern latitude and Long_W for western longitude.

Where LAT_N is the northern latitude, and LONG_W is the western longitude.

Lets Input

Let us say that the CITY only has four entries: XYZ, CDE, LMNO, and WXY

then the output will be

CITY names are CDE, LMNO, WXY, XYZ with lengths such as 3, 4, 3, and 3. In the given CITY, the most extended City is LMNO. However, three options are available for the shortest length. So we choose the CITY of alphabetically, So CDE choose.

Query for two cities in STATION will be as follow:

{

Select CITY,

char_length(CITY) as len_city

from STATION

where length(CITY)=(select length(CITY)

from STATION

order by length(CITY) LIMIT 1)

Order by CITY LIMIT 1)

(select CITY,

length(CITY) as length_city

from STATION

where length(CITY)=(select length(CITY)

from STATION

order by length(CITY) DESC LIMIT 1)

Order by CITY DESC LIMIT 1)

ORDER BY length(CITY);

Such as

SELECT city, LENGTH(city) FROM station

WHERE LENGTH(city)=(SELECT LONGS(LENGTH(city)) FROM station)

SELECT city, LENGTH(city)

FROM STATION

WHERE LENGTH(city)=(SELECT SHORTEST(LENGTH(city)) FROM STATION)

ORDER BY CITY;