title: How to throw out WEEKENDS from calculation in SQL QUERY?
body: <p>I have SQL query which returns average utilization for some worker for previous year.</p>
  
  <pre><code>SELECT Name, AVG (hsum)
  FROM
  (
      SELECT Name,sum((number_hours)/8)*100 AS hsum
      FROM
      T1
      WHERE name='PERSON_A' and bookeddate&gt;='2012-01-01' and booked_date&lt;='2012-12-31'
      GROUP BY name,booked_date
  ) t
  </code></pre>
  
  <p>Now I want to exclude weekends for booked date for calculation? how to do it? I am using mysql
  thank you</p>