Write a SQL query using complex joins and aggregations to count active incident records across multiple tables based on specific regional criteria.
You are practicing as a guest. Sign up free to get your answer graded with AI feedback. Your draft stays right here.