DataLemur: Patient Support Analysis

1
2
3
4
5
6
7
8

WITH call_counts AS (
  SELECT policy_holder_id, COUNT(case_id) AS count
  FROM callers
  GROUP BY policy_holder_id
)
SELECT COUNT(*) AS member_count
FROM call_counts
WHERE count >= 3