I am delighted that when I resolved the query in this way. Finally, I understand that I can add a null column when I combine tables if there is no data in one of them. I can apply multiple filters to make the query more accurate.
I can validate the data directly, and the numbers look so good.