将MySQL数据分组到一周中的哪一天

I'm attempting to separate my database entries into the number of entries that fall on each day of the week (Mon=43, Tue=35...) with no regard for month or year. The result from the query below return eight results instead of seven and the number of results for each day is incorrect. I'm attempting to separate my database entries