I have a table with 3 fields(StoreId, Date, SalesTotal). How can I write a sql statement to find the avg salestotal within a date range for a certain storeid? Thanks in advance.
