sql tips: you can group by anythingpic.twitter.com/YoJVlUyghG
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
Accordingly, if a database allows GROUP BY alias as an extension, you have the possibility that adding a column to the base tables might silently change the meaning of the query, since GROUP BY real_column must be preferred over GROUP BY alias if both exist.
The standard-compliant way to do this is to use a subquery: SELECT x FROM (select (expression) AS x FROM ...) AS s GROUP BY s.x;
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.