CREATE TABLE `history`(
`time` datetime,
`Profit` int,
`type` int
);
INSERT INTO `history` VALUES
('2021-11-29 10:10:10', 5, 1),
('2021-11-30 10:10:10', 5, 1),
('2021-11-30 10:10:12', 5, 1);
-- [{"time":"30.11.2021","Profit":10},{"time":"29.11.2021","Profit":26},{"time":"28.11.2021","Profit":12},{"time":"27.11.2021","Profit":10},{"time":"26.11.2021","Profit":13},{"time":"25.11.2021","Profit":13},{"time":"24.11.2021","Profit":13}]
SELECT DATE(`time`) `Day`, SUM(`Profit`) `DaylyProfit`
FROM `history`
WHERE `time` > DATE_SUB(CURRENT_DATE, INTERVAL 6 DAY)
GROUP BY `Day`;