Can someone help me understand why different results are coming IN SUM_BUDGET column for below queries :-
FIRST QUERY
select distinct (cntry), SUM (B.BUDGET_SALES) AS SUM_BUDGET from [publish].[LCM_COMMON_HNB_WEEKLY_ACTUAL] A left outer join ANALYSE.LCM_COMMON_BUDGET_SALES B ON A.cntry=B.COUNTRY AND A.week_commencing=B.WEEK_START_DATE where A.week_commencing='04-01-2021' group by cntry;
OUTPUT :-
2.1m questions
2.1m answers
60 comments
56.9k users