
Assuming invsopoitm is required, the following result was found.
sum up the profits as well as include the customer name and other invoice references for the client's report: SELECT MAX(invsopoitm."Invoice Date") AS "Invoice Date", MAX(invsopoitm."Invoice Ref") AS "Invoice Ref", MAX(c."Customer Name") AS "Customer",...

bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF