Need a SQL query to get data from sql database for a given period with certain condition : I have sql database namely sales.dbo with 7 columns. First column contains different sales person names, on column 2 to 6 other information, on column 7,sales average. What i need is a query to get all sales person details(all seven columns in excel) if their sales average is more than 60 % between a given date. For example:

In my database, i have data from 01/05/2016 to 31/05/2016, if i enter a period in my excel sheet between 25/05/2016 to 31/05/2016 and my required average for ex.60% (should be changed as per my need), then i need all the sales person details who continuously have sales average of more than 60% between 25 to 31st May 2016.

If a sales man average was dropped below 60 % on 28th May , then i don't want to see him on my report.In simple words, i need all sales person who continuously hitting 60 % or more on average sales within my search period.

Thanks in Advance.