title: SQL: How many visits per weekday?
body: <p>I have a table like this one:</p>
  
  <pre><code>Visit,Visitdate;
  A,2015-03-31T11:11:00.000+0000;
  B,2015-03-31T12:11:00.000+0000;
  C,2015-04-31T16:11:00.000+0000;
  D,2015-07-31T16:15:00.000+0000;
  C,2015-04-31T16:11:00.000+0000;
  D,2015-07-31T16:15:00.000+0000;
  </code></pre>
  
  <p>...</p>
  
  <p>I need to know the number of visits per weekday (Monday, Tuesday,...)</p>
  
  <p>I tried with the following code but it does not work:</p>
  
  <pre><code>`SELECT date_format (Visitdate, 'EEEE') FROM table,
  COUNT (*) AS VisitCount from table group by Visitdate`
  </code></pre>
  
  <p>With <code>SELECT date_format (Visitdate, 'EEEE') FROM table</code> I am able to specify the weekday.</p>
  
  <p>With <code>SELECT Visitdate, COUNT (*) AS VisitCount from table group by Visitdate</code> I am able to count the number of visits per <code>YYYY-MM-DDTHH:MM:SS</code></p>
  
  <p>However I am not able to combine both codes to make it work.</p>
  
  <p>Thanks in advance!</p>