Order Summary By Date & SKU


I have a table of orders by date and all other details like SKU, selling price, city etc.,
How to generate a report of everyday sales by SKU on another table?
I made date as the key column in orders table and linked it in summary table? But I have to manually enter the dates and I can’t figure out how to generate SKU wise list?