Not sure where to go with this.
I have a table that has three columns.
SKU, Date, Qty
Each SKU can have mulitple dates and quantities. I would like to create a query that select each SKU and gives the earliest date(min/max) and the quantity associated with the date.