MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE tABLE Orders (OrderID int, client varchar(10),ClientID int,  Date date) 
INSERT INTO Orders VALUES ( 1,'test1',1,NOW() - INTERVAL 2 YEAR);
INSERT INTO Orders VALUES ( 2,'test2',2,NOW() - INTERVAL 2 YEAR)
CREATE Temporary table t_temop (Orderclinet varchar(100)) 
CREATE PROCEDURE totalOrders (IN p_client VARCHAR(10))
BEGIN
     INSERT INTO t_temop
    SELECT CONCAT(MAX(client), ": ", COUNT(OrderID), " order(s)") 
    FROM Orders 
    WHERE YEAR(Date) = 2022 AND ClientID = p_client;
END
CALL totalOrders(1);
  CALL totalOrders(2);
SELECT * FROM t_temop


Orderclinet


test1: 1 order(s)

test2: 1 order(s)