DROP VIEW IF EXISTS team_amount_project_list_view;
CREATE VIEW team_amount_project_list_view (
 offer_id,
 total_project_amount
) as 
SELECT
    `offer_id`,
    SUM(gross_amount) AS `total_project_amount`
FROM
    `offer_partitipants`
GROUP BY
    `offer_id`;