Целосна анализа на сите пациенти - расположение, успешност на консултации и терапија

SELECT
    p.id_user,
    u.name || ' ' || u.surname AS Patient_Name,
    COUNT(DISTINCT c.id_consultation) AS Total_Consultations,
    COUNT(DISTINCT th.id_therapy) AS Total_Therapies,
    ROUND(AVG(d.daily_rating), 2) AS Avg_Mood,
    MIN(d.daily_rating) AS Lowest_Mood
FROM project.patient p
         JOIN project.user u ON u.id_user = p.id_user
         LEFT JOIN project.consultation c ON c.id_patient = p.id_user
         LEFT JOIN project.therapy th ON th.id_consultation = c.id_consultation
         LEFT JOIN project.diary d ON d.id_patient = p.id_user
GROUP BY p.id_user, u.name, u.surname
ORDER BY Avg_Mood ASC;