AskMy2

INSERT Reporti(Client_name, Client_id, Orders_total, Value_total, Period)
SELECT Name, Clients.id, count(Orders.id), sum(Value_total), Date
FROM Clients Join Orders on Clients.id=Orders.Client_id
WHERE YEAR(Date) = YEAR(DateL) AND MONTH(Date) = MONTH(DateL)
GROUP BY Clients.id;