Custom Column's Query showing Discrepancy

Hello, Let me share the data first Country                        Email Name Germany                      EMEA_CHAN_PN_Newsletter_EMAIL_Q3_08_2021_de_AT_BSD Germany                      EMEA_CHAN...