Skip to content

Instantly share code, notes, and snippets.

@QuatoHub

QuatoHub/Quato.sql

Created March 29, 2022 11:35
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save QuatoHub/01d69ae65d8bd20eb4f970f96a46af20 to your computer and use it in GitHub Desktop.
Save QuatoHub/01d69ae65d8bd20eb4f970f96a46af20 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Quato.sql
SELECT ROUND(LAT_N, 4) FROM STATION AS S
WHERE (SELECT COUNT(*) FROM STATION WHERE LAT_N < S.LAT_N)
= (SELECT COUNT(*) FROM STATION WHERE LAT_N > S.LAT_N);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment