I have attached 2 files.
One contains a sample of some table data. The other contains the desired query output based on the sample data.
Basically, that table has 3 columns name, call date and reason for calling.
What I'm trying to do is write a query that will list the previous 4 week end dates (considering sunday the end date) with the issues called in for each of the weeks for a given caller if the caller calls at least 3 times in a given week.
Any help with the query syntax would be greatly appreciated!
Start Free Trial
