SELECT
ORGANIZATION_NAME,
COUNTERPARTY_NAME,
COUNTERPARTY_INN,
AGREEMENT_NUMBER,
TYPE_AGREEMENT,
TYPE_BUSINESS,
DAYS_OVERDUE,
GUID_AGREEMENT,
GUID_COUNTERPARTY,
REPORT_DATE
FROM XXXXXX
where (TOTAL_AMOUNT_DZ_AGREEMENT >0 and AGREEMENT_NUMBER <> '-')
and (TYPE_BUSINESS = '-' or DAYS_OVERDUE = '-')
and report_date = '2019-02-01 00:00:00' --УКАЗЫВАЕМ АНАЛИЗИРУЕМ ДАТУ ОТЧЕТНОСТИ.
GROUP BY
ORGANIZATION_NAME,
COUNTERPARTY_NAME,
COUNTERPARTY_INN,
AGREEMENT_NUMBER,
TYPE_AGREEMENT,
TYPE_BUSINESS,
DAYS_OVERDUE,
GUID_AGREEMENT,
GUID_COUNTERPARTY,
REPORT_DATE;