
Write a PostgreSQL query to identify monthly customer interaction trends across Mölnlycke channels. For each month and customer segment, return total interactions, resolved interactions, resolution rate, and the most-used channel. Only keep month-segment groups with at least 2 interactions.
Joining fact and dimension tablesMonthly aggregation with date formattingConditional aggregation using CASE WHENUsing CTEs to isolate channel ranking logic