sql server - Can someone help me understand why different results are coming for below query

Question

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 :-

cntry	SUM_BUDGET
HK	NULL
SG	7767135054.63
ID	NULL
MO	NULL
MY	12441719937.28

question from:https://stackoverflow.com/questions/66060638/can-someone-help-me-understand-why-different-results-are-coming-for-below-query

Answer 1

Waitting for answers