Calculating Distinct Ids for Weekly Cohort in SQL: Improved Approach Using Window Functions

Resolving Issues with MAX Aggregate Queries in Postgres (Redshift) and MySQL