Hello friends, imagine a survey system with a table structure consisting of ControlID, TitleID, SurveyID, UserID, IP, and Date fields. When users vote, let the fields be populated as follows: ControlID = AUTO, TitleID = 5, SurveyID = 143, UserID = 183, IP = 185.154.85.2, Date = 1510583116. What I want to do is to list the most voted titles from now to 7 days ago. I am trying to use ORDER BY COUNT(TitleID) DESC but it seems to not give the correct result. How else can I pull this data?