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

Understanding the Issue with Node.js and SQL: Inserting Rows Multiple Times