In a scenario where you need to calculate a rolling average of daily sales over a period of six months, which SQL technique would be most appropriate, and how would you implement it in a query? Consider the use of window functions and data grouping.