DROP VIEW IF EXISTS additional_cost_historical_project_list_view;
CREATE VIEW additional_cost_historical_project_list_view (
 historical_project_id,
 additional_costs
) as
SELECT
        historical_project_id,
        ROUND(COALESCE(SUM(amount),
        0),
        2) AS additional_costs
    FROM
        historical_project_additional_costs
    GROUP BY
        historical_project_id