SELECT SUM(QTY7+QTY8+QTY9+QTY10+QTY11+QTY12)
FROM TABLE1
WHERE YEAR = :YEAR

CREATE TABLE CUPBOARD (
      DT DATE NOT NULL CHECK (DAY(DT) =  1 ),  -- только 1ое число месяца
 
      ACTION INT NOT NULL,  -- отгружено, получено и пр.
 
      QTY INT NOT NULL CHECK (QTY >  0 ),
      CONSTRAINT CPB_PK PRIMARY KEY (DT, ACTION)
);

 -- получить сумму за последние 6 месяцев
 

SELECT ACTION, SUM(QTY)
FROM CUPBOARD
WHERE DATE() - DT <= INTERVAL  6  MONTH;

 -- получить отчёт
 

SELECT ACTION,
       SUM(CASE MONTH(DT) WHEN  1  THEN QTY ELSE  0  END) AS Jan,
      ....
       SUM(CASE MONTH(DT) WHEN  12  THEN QTY ELSE  0  END) AS Dec
FROM CUPBOARD
GROUP BY ACTION
ORDER BY ACTION;

....
WHERE YEAR(DT) = :YEAR
GROUP BY ...