DROP VIEW IF EXISTS team_offers_project_list_view;
CREATE VIEW team_offers_project_list_view (
 project_id,
 total_team_amount
) as 
SELECT
    `project_id`,
    SUM(
        gross_amount + reviser_gross_amount + editor_gross_amount + project_manager_gross_amount
    ) AS total_team_amount
FROM
    `project_offers`
GROUP BY
    `project_id`;