2025-04-24

例行事项

• 前端学习了吗？

• cursor 了解了吗

• EPED 练习了吗

主观事项

• 今天做的事是否聚焦当前目标？

• 只做少而好的事？

• 当日有哪些经验和改进的空间？

改进的空间：

工作上需要完成的事

今日记录

反思

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;