- 1
Query the two Cities In Station With Shortest and Longest City names.
MySQL Query
2 odpowiedzi
0
¿What is the question? If you need help, please show your attempt first.
0
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;