https://softwarepatternslexicon.com/sql/case-studies/implementing-real-time-analytics-with-sql/