Help with AVG()

Hi Everyone I am trying to figure out how to write a SELECT query that will give me the average of bible_anagrams.views starting on the date specified in bible_anagrams_rss_feed.rss_feed_date and the previous 6 calendar days (for a total of 7 days). What I am trying to figure out is the average of how many times the anagrams RSS Feed were accessed between June 1st and 7th, June 2nd and 8th, June 3rd and 9th, etc. - There is 1 row for each date in the table bible_anagrams_rss_feed. I tried the following syntax, but it is giving me an overall average, not by the date ranges: SELECT AVG(bible_anagrams.views) AS average_views FROM bible_anagrams INNER JOIN bible_anagrams_rss_feed ON bible_anagrams.reference = bible_anagrams_rss_feed.bible_anagrams_reference ORDER BY bible_anagrams_rss_feed.rss_feed_date DESC LIMIT 7 I am wanting the query I am asking help for to be included as one of the mySQL results, where I have indicated “AVERAGE VIEWS QUERY HERE” (although if there is a better way I am opening to learning it): SELECT bible_anagrams_rss_feed.rss_feed_date , bible_anagrams.reference, bible_anagrams.bible_anagram_word , bible_anagrams.views , ( AVERAGE VIEWS QUERY HERE ) AS average_views FROM bible_anagrams_rss_feed INNER JOIN bible_anagrams ON bible_anagrams.reference = bible_anagrams_rss_feed.bible_anagrams_reference ORDER BY bible_anagrams_rss_feed.rss_feed_date DESC Thanks for helping me, Ron The Verse of the Day “Encouragement from God’s Word” http://www.TheVerseOfTheDay.info