Most common week days query

[AYELLEputonsomeaviators]

Have this query:\[code\]SELECT HOUR( DATE ) AS hr, COUNT( * ) AS cntFROM usersGROUP BY hrORDER BY cnt DESC\[/code\]DATE is a DATETIME field and the above query shows me the most common hours in the date field.I'm trying to improve it but not sure how to do it, I want to break it down by week days and within each week day to most common hours.