---

-- Есть ли вообще платежи за 2024 год?
SELECT 
    EXTRACT(YEAR FROM date) AS year,
    order_payment_type_id,
    COUNT(*) AS cnt
FROM back_office.incoming_order
WHERE order_payment_type_id IN (18, 40)
GROUP BY 1, 2
ORDER BY 1 DESC



-- Есть ли заполненные individual_id по нужным типам платежей?
SELECT 
    order_payment_type_id,
    COUNT(*)                            AS cnt_total,
    COUNT(individual_id)                AS cnt_with_individual,
    COUNT(payer_individual_id)          AS cnt_with_payer_individual,
    COUNT(contract_id)                  AS cnt_with_contract
FROM back_office.incoming_order
WHERE order_payment_type_id IN (18, 40)
GROUP BY 1