Re: Help with AVG()

I have continued to work on the average query I need help. I am still needing help. What I don’t understand is why bible_anagrams_rss_feed.rss_feed_date BETWEEN bible_anagrams_rss_feed.rss_feed_date AND DATE_SUB( bible_anagrams_rss_feed.rss_feed_date , INTERVAL -1 WEEK ) won’t isn’t selecting the 7 consecutive dates leading up to and including the date of bible_anagrams_rss_feed.rss_feed_date I am only getting the value of bible_anagrams.views from the current date as the value of average_views in the query: SELECT bible_anagrams_rss_feed.rss_feed_date , SUM( bible_anagrams.views ) AS total_views , SUM( bible_anagrams.views ) / COUNT(bible_anagrams_rss_feed.reference) AS average_views FROM bible_anagrams_rss_feed INNER JOIN bible_anagrams ON bible_anagrams_rss_feed.bible_anagrams_reference = bible_anagrams.reference WHERE bible_anagrams_rss_feed.rss_feed_date BETWEEN bible_anagrams_rss_feed.rss_feed_date AND DATE_SUB( bible_anagrams_rss_feed.rss_feed_date , INTERVAL -1 WEEK ) GROUP BY bible_anagrams_rss_feed.rss_feed_date ORDER BY bible_anagrams_rss_feed.rss_feed_date DESC rss_feed_date Descending total_views average_views 2011-06-13 12:00:02 13 13.0000 2011-06-12 12:00:01 10 10.0000 2011-06-11 12:00:02 18 18.0000 2011-06-10 12:00:02 14 14.0000 2011-06-09 12:00:01 20 20.0000 2011-06-08 12:00:01 28 28.0000 2011-06-07 12:00:03 15 15.0000 2011-06-06 12:00:02 21 21.0000 2011-06-05 12:00:01 20 20.0000 2011-06-04 12:00:02 33 33.0000 2011-06-03 12:00:02 23 23.0000 2011-06-02 12:00:02 25 25.0000 2011-06-01 12:00:01 13 13.0000 2011-05-31 12:00:02 41 41.0000 2011-05-30 12:00:01 27 27.0000 Ron The Verse of the Day “Encouragement from God’s Word” http://www.TheVerseOfTheDay.info