<prompt> Kutokana na meza ya mauzo ya bidhaa na nguzo ProductID, SaleDate, na SaleAmount, kuandika SQL query kupata juu 5 bidhaa na mauzo ya juu wastani wa kila siku katika wiki iliyopita.  <response>: Here is a SQL query that will give you the top 5 products with the highest daily average sales within the past week:SELECT TOP 5 ProductID, AVGSaleAmount AS AvgSaleAmountFROM YourTableNameHereWHERE SaleDate DATEADDday, -7, GETDATEGROUP BY ProductIDORDER BY AvgSaleAmount DESCIn the above query, replace YourTableNameHere with the actual name of your table. The query filters results where SaleDate is greater than 7 days ago and calculates the average sale amount per product for the past week. Finally, the query selects the top 5 results with the highest average sale amount. 