total count each day sorted, result grouped by week

My query looks like this right now pretty straightforward:

select 
    count(*), 
    date(visit_date), 
    DATE_FORMAT(visit_date,"%a") 
from visits 
group by date(visit_date)

Here is the result:

http://d.pr/FmMg

what I want 开发者_如何学运维to happen is:

1. for each week the count is sorted

Can you modify my query so it satisfies the criteria?

Assuming, you no longer need the count by day and are ONLY looking for count by week:

SELECT
   count(*),
   yearweek(visit_date)
FROM visits
GROUP BY yearweek(visit_date)
ORDER BY yearweek(visit_date) ASC;

Are you trying to do like this? - you can use Datepart to get week number and sort by that.

select
    count(*),
    date(visit_date),
    DATE_FORMAT(visit_date,"%a")
from
    visits
group by
    date(visit_date)
order by 
    datepart(yyyy,visit_date),
    datepart(wk,visit_date),
    count(*)