i am having the sql below:SELECT TOP (100) SAMINC.dbo.OESTATS.YR as YEAR , SUM(SAMINC.dbo.OESTATS.SALESAMTF) AS TotalSalesFROM SAMINC.dbo.OESTATS INNER JOIN dbo.Company ON SAMINC.dbo.OESTATS.LINVCUST = dbo.Company.Comp_IdCust COLLATE Latin1_General_BINGROUP BY SAMINC.dbo.OESTATS.YRthat generated the results below:

YEAR TotalSales2019 21932.3602020 46448.040

it is find in SQL, the software that i am using automatically adds a field called comp_companyid to it so the sql becomes