SQL window functions: how OVER() workspic.twitter.com/zQhPqtTzQy
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
Yet, in Example 2 there are a different number of rows..??..
These examples aren't showing the actual query result.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.