**MODULE**: Analytics **SCOPE**: Chats **SQL**: DSL/Resql/analytics/POST/chat-avg-duration.sql ### Acceptance Criteria - [x] Counted chats need to have an ENDED status (as-is). - [x] Only unique chats are taken into account (as-is). - [x] Calculation is from the most recent message created - the oldest message created (as-is). - [x] Only average is used (as-is). - [x] Test chats are excluded (as-is).