从触发器更新表

Question

我在数据库中有以下表格：

CREATE TABLE `CRUISE-RES` (
`cruiseid` INT,
`end-day` DATE,
`start-day` DATE
PRIMARY KEY (`cruiseid`)); 

CREATE TABLE `ROOM` (
`cruise-id` INT,
`price` FLOAT,
FOREIGN KEY (`cruise-id`));

CREATE TABLE `PROFIT` (
`cruiseid` INT,
`total` FLOAT);

具有以下示例表插入：

-- cruise table inserts
insert into `CRUISE-ID` (`cruiseid`,`start-day`,`end-day`)
values (1, '2022/01/01', '2022/01/05'), (1, '2022/01/05', '2022/01/10'), (2, '2022/01/05', '2022/01/10')

-- room table inserts
insert into ROOM (price,`cruise-id`)
values (5,1), (10,1), (25,2)

我还具有以下功能，该功能根据每天的Cruise-Res *价格天数，显示每个Cruiseid的利润。

SELECT c.`cruiseid`, sum(rm.`price`*(DATEDIFF(c.`end-date`, c.`start-date`))) AS 'total_profit'
FROM ROOM rm
JOIN `CRUISE-RES` c
ON rm.`cruise-id` = c.cruiseid
GROUP BY rm.`cruise-id`,'cruiseid'

如何在每次插入巡航分区表之后更新利润表的触发器上使用此信息？