I have a couple of tables looking like this:
I want the result to be like this:
This should be for all transactions in a certain month and year that is based on sentDate that holds when the order was sent. Also, only the orders with orderStatusID = 3 should be shown.
How can I achieve this?
Thanks for help!