
Assuming invitm is required, the following result was found.
in addition to including the customer ID and invoice ID, I'm calling this one "Invoice Items vs SoPo Items": SELECT MAX(invitm."Invoice ID") AS "Invoice ID", MAX(inv."Invoice Date") AS "Invoice Date", MAX(abs_month(inv."Invoice Date")) AS "Invoice Month...

bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF