Sum amount based on date

ReddyReddy 1 Reputation point
2021-09-07T03:37:54.417+00:00

Hi . I have an issue in writing the query for below scenario
CompanyA. Sep 2021. 45000rupees
CompanyA. Jan 2021. 3300rupees

CompanyB. March 2021. 5000rupees

CompanyB. Jan 2021. 6000rupees

Now I need to find the company amount as different if the date is more 6 months . If not sum the amount and show as 1 row

Microsoft BizTalk Server
Microsoft BizTalk Server
A family of Microsoft server products that support large-scale implementation management of enterprise application integration processes.
356 questions
{count} votes