I'm stitching together QUERY1 and QUERY2 with a UNION query (QUERY3).
In QUERY1 there are several identical records.
After the UNION several records have been left out, and there are now no identical records.
Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.