Summarize support tickets by department with conditional SQL counts for open, in-progress, and closed statuses.
