title: MySQL AVG(COUNT(*) - Orders By day of week query?
body: <p>This query has baffled me... I've searched the web work over a day now and I have tried numerous things.</p>
  
  <p>I want to get the avg number of orders for every day of the week from my db. I can pull the total # with COUNT just fine. But I just can't figure out how to get the AVG of COUNT on a GROUP BY. I've tried subqueries... functions... everything... nothing works... maybe someone can throw me a bone.</p>
  
  <p>Here is the query I started with below. I know AVG(COUNT(*)) won't work but I'll leave it at that because it shows what I want to do. </p>
  
  <pre><code>SELECT 
      AVG(COUNT(*)) AS avgorders, 
      SUM(total) AS ordertotal, 
      DAYNAME(STR_TO_DATE(order_time,'%m/%d/%Y %H:%i')) AS day 
  FROM data 
  GROUP BY day 
  ORDER BY DAYOFWEEK(STR_TO_DATE(order_time,'%m/%d/%Y %H:%i')) ASC
  </code></pre>