Rolling Time Window with Distinct Count in Big SQL using DENSE_RANK() Function

Python SQLite String Comparison with SQL Queries and Window Functions