Editing Mental health expansion (section)

==== group sessions ====
<syntaxhighlight lang="postgresql" line>
 WITH params AS (
  -- Set the first day of the reporting month here
  SELECT DATE '2025-06-01' AS rpt_start
),
session_attendance AS (
  SELECT
    ga."Id" AS group_id,
    ga."Date" AS session_date,
    COUNT(DISTINCT gcp."ClientParticipantId") AS attendees
  FROM kotahi.groupactivities ga
  JOIN kotahi.groupactivityclientparticipant gcp
    ON ga."Id" = gcp."GroupActivityId"
  CROSS JOIN params p
  WHERE ga."ServiceId" = 6
    AND ga."Date" >= p.rpt_start
    AND ga."Date" <  (p.rpt_start + INTERVAL '1 month')
    AND gcp."Attendance" = 1
  GROUP BY ga."Id", ga."Date"
)
SELECT
  CASE
    WHEN attendees BETWEEN 2 AND 14 THEN '02–14'
    WHEN attendees >= 15 THEN '15+'
    ELSE 'Fewer than 2 (ignored)'
  END AS session_size_band,
  COUNT(*) AS session_count
FROM session_attendance
WHERE attendees >= 2         -- exclude 1-person sessions which I doubt will ever happen 
GROUP BY session_size_band
ORDER BY session_size_band;
</syntaxhighlight>