SELECT
    Organization.NAME AS Организация,
    Contract.CONTRACT_NO AS Договор,
    Contract.PRICE AS Стоимость,
    Contract.STATUS AS Статус
FROM Organization, Contract
WHERE Organization.ID = Contract.ORG1_ID
   OR Organization.ID = Contract.ORG2_ID;

SELECT
    Organization.NAME AS Организация,
    COUNT(Contract.ID) AS Количество_договоров,
    AVG(Contract.PRICE) AS Средняя_стоимость
FROM Organization, Contract
WHERE Organization.ID = Contract.ORG1_ID
   OR Organization.ID = Contract.ORG2_ID
GROUP BY Organization.NAME;