Write an advanced SQL query to calculate the rolling 7-day unique viewership for a specific advertising campaign across multiple regions.
You are practicing as a guest. Sign up free to get your answer graded with AI feedback. Your draft stays right here.