System design and DB schema and algorithmic approach towards designing top 10 tweet functionality in last hour/past 24 hours.

Extension: Do a region wise analysis as well