How to get a list of all Shop Orders Awaiting Shipment by Customer & SKU?

Hello I am a beginner still learning but I want to display to a customer (site member):

  • a list of all quantities purchased “Awaiting Shipment” by SKU in total for all orders placed

so a customer can log in and can see all item quantities by product type which they have paid for which have not yet been shipped

e.g. maybe 10 orders with quantities Awaiting Shipment but TOTALS are:

SKU A 100 items Awaiting Shipment
SKU B 50 items Awaiting Shipment

Thank you in advance

Anybody? Sorry I am a leaner and guess I just need to know how to query the Shop Orders database from a browser with some query parameters ?