Skip to content

Instantly share code, notes, and snippets.

@abevieiramota

abevieiramota/a.sql

Created October 10, 2022 12:58
Show Gist options
  • Save abevieiramota/838607166450bd160ab48e335d2c84c4 to your computer and use it in GitHub Desktop.
Save abevieiramota/838607166450bd160ab48e335d2c84c4 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
a.sql
-- retorna a cidade com maior nome
(
select city, char_length(city)
from station
order by 2 desc, 1 asc
limit 1
)
union all
-- retorna a cidade com menor nome
(
select city, char_length(city)
from station
order by 2 asc, 1 asc
limit 1
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment