DROP VIEW IF EXISTS additional_cost_list_view;
CREATE VIEW additional_cost_list_view (
 project_id,
 additional_costs
) as
SELECT
    `project_id`,
    ROUND(COALESCE(SUM(amount),
    0),
    2) AS `additional_costs`
FROM
    `project_additional_costs`
GROUP BY
    `project_id`;