I have a data like below. I need to write a query to get the result for rolling 6 months on each month. Please find mentioned expected result in the attached screenshot.
Can any one help me how to write the logic for rolling 6 months.
I am very new to SQL, hope someone will help me to get this requirement.
And also please mention any practice links where i can do real time scenario to improve the SQL query writing with real time requirements.