Query the two Cities In Station With Shortest and Longest City names.

Question

MySQL Query

Answer 1

¿What is the question? If you need help, please show your attempt first.

Answer 2

Try to use MAX() to get longest name, and MIN() to get shortest name.

SELECT MIN(city_name) AS shortest,
MAX(city_name) AS longest
FROM cities;