Write a SQL query to find the rolling 7-day average of active users, partitioned by specific clinical cohorts at nference.
