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
That said, the use of the same expression in both the select-list and GROUP BY also seems to be fairly widely supported. This puzzles me a little, because it caused me headaches when implementing GROUPING SETS for postgresql
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.