SELECT
status,
COUNT(*) AS count,
COUNT(*) * 100.0 / SUM(COUNT(*)) OVER () AS percentage
FROM
assessment.assessment
WHERE
assessment_profile_id = 685
GROUP BY
status;
select * from assessment.assessment left join assessment_profile.assessment_profile_version
on assessment.assessment_profile_id = assessment_profile.assessment_profile_version.id
where health_facet_id = 1
select
status,
COUNT(*) AS count,
COUNT(*) * 100.0 / SUM(COUNT(*)) OVER () AS percentage
from assessment.assessment left join assessment_profile.assessment_profile
on assessment.assessment_profile_id = assessment_profile.assessment_profile.id
where health_facet_id = 1
and assessment.created_at > '2024-01-01' and assessment.created_at < '2025-01-01'
GROUP BY
assessment.assessment.status;