thank you guys your answer help me so much 🙂 i find the solution

SELECT SUM(cost) as income,

DATEPART(Month, visiting_date) as month,

DATEPART(Year, visiting_date) as year

FROM table1

GROUP BY DATEPART(Year, visiting_date),...