sql queries run in this order:pic.twitter.com/OTJEjUuVIE
You can add location information to your Tweets, such as your city or precise location, from the web and via third-party applications. You always have the option to delete your Tweet location history. Learn more
allowing aliases in GROUP BY is a fairly common extension to the SQL spec, even though it violates the spec by changing the result of some standard, but obscure, queries.