So I have a sql table called orders in which I am importing order information thru excel sheet. Each row of the excel sheet contains item details from a particular order that belong a customer.
The issue I am facing is a customer can contain more than one order. The only unique fields I see in the file is order_id and billing_email address.
How do I display all the orders a particular customer has placed. I am attaching a sample excel file, as you can see I am trying to display all the orders placed for example by john doe with the total order amt he ever purchased.
Any advice is appreciated.