---

SELECT
    rd.strategy_id,
    st.name AS strategy_name,
    COUNT(*) AS detail_rows,
    COUNT(rd.pension_scheme_id) AS rows_with_scheme,
    COUNT(rd.uidpensionscheme) AS rows_with_scheme_uid
FROM back_office.report_conformity_pu_bu_detail rd
LEFT JOIN prod_line.hb_invest_strategy st
    ON st.id = rd.strategy_id
WHERE rd.report_conformity_pu_bu_id = 39
GROUP BY
    rd.strategy_id,
    st.name
ORDER BY rd.strategy_id NULLS LAST;